{
 "metadata": {
  "name": "",
  "signature": "sha256:9f04c02543c2721beea538598849f7ba7454ca0ee142794537ede86cb1f68a08"
 },
 "nbformat": 3,
 "nbformat_minor": 0,
 "worksheets": [
  {
   "cells": [
    {
     "cell_type": "code",
     "collapsed": false,
     "input": [
      "from db import DB\n",
      "\n",
      "db = DB(filename=\"./baseball-archive-2012.sqlite\", dbtype=\"sqlite\")\n",
      "db"
     ],
     "language": "python",
     "metadata": {},
     "outputs": [
      {
       "output_type": "stream",
       "stream": "stderr",
       "text": [
        "Indexing schema. This will take a second...finished!\n"
       ]
      },
      {
       "metadata": {},
       "output_type": "pyout",
       "prompt_number": 1,
       "text": [
        "DB[sqlite][localhost]:5432 > None@None"
       ]
      }
     ],
     "prompt_number": 1
    },
    {
     "cell_type": "code",
     "collapsed": false,
     "input": [
      "db.tables.allstarfull"
     ],
     "language": "python",
     "metadata": {},
     "outputs": [
      {
       "html": [
        "<table>\n",
        "    <tr>\n",
        "        <th>Column</th>\n",
        "        <th>Type</th>\n",
        "    </tr>\n",
        "    <tr>\n",
        "        <td>playerID</td>\n",
        "        <td>TEXT</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "        <td>yearID</td>\n",
        "        <td>INTEGER</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "        <td>gameNum</td>\n",
        "        <td>INTEGER</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "        <td>gameID</td>\n",
        "        <td>TEXT</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "        <td>teamID</td>\n",
        "        <td>TEXT</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "        <td>lgID</td>\n",
        "        <td>TEXT</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "        <td>GP</td>\n",
        "        <td>INTEGER</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "        <td>startingPos</td>\n",
        "        <td>INTEGER</td>\n",
        "    </tr>\n",
        "</table>"
       ],
       "metadata": {},
       "output_type": "pyout",
       "prompt_number": 2,
       "text": [
        "+-----------------------+\n",
        "|      allstarfull      |\n",
        "+-------------+---------+\n",
        "| Column      | Type    |\n",
        "+-------------+---------+\n",
        "| playerID    | TEXT    |\n",
        "| yearID      | INTEGER |\n",
        "| gameNum     | INTEGER |\n",
        "| gameID      | TEXT    |\n",
        "| teamID      | TEXT    |\n",
        "| lgID        | TEXT    |\n",
        "| GP          | INTEGER |\n",
        "| startingPos | INTEGER |\n",
        "+-------------+---------+"
       ]
      }
     ],
     "prompt_number": 2
    },
    {
     "cell_type": "code",
     "collapsed": false,
     "input": [
      "db.tables.allstarfull.head()"
     ],
     "language": "python",
     "metadata": {},
     "outputs": [
      {
       "html": [
        "<div style=\"max-height:1000px;max-width:1500px;overflow:auto;\">\n",
        "<table border=\"1\" class=\"dataframe\">\n",
        "  <thead>\n",
        "    <tr style=\"text-align: right;\">\n",
        "      <th></th>\n",
        "      <th>playerID</th>\n",
        "      <th>yearID</th>\n",
        "      <th>gameNum</th>\n",
        "      <th>gameID</th>\n",
        "      <th>teamID</th>\n",
        "      <th>lgID</th>\n",
        "      <th>GP</th>\n",
        "      <th>startingPos</th>\n",
        "    </tr>\n",
        "  </thead>\n",
        "  <tbody>\n",
        "    <tr>\n",
        "      <th>0</th>\n",
        "      <td> aaronha01</td>\n",
        "      <td> 1955</td>\n",
        "      <td> 0</td>\n",
        "      <td> NLS195507120</td>\n",
        "      <td> ML1</td>\n",
        "      <td> NL</td>\n",
        "      <td> 1</td>\n",
        "      <td>NaN</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "      <th>1</th>\n",
        "      <td> aaronha01</td>\n",
        "      <td> 1956</td>\n",
        "      <td> 0</td>\n",
        "      <td> ALS195607100</td>\n",
        "      <td> ML1</td>\n",
        "      <td> NL</td>\n",
        "      <td> 1</td>\n",
        "      <td>NaN</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "      <th>2</th>\n",
        "      <td> aaronha01</td>\n",
        "      <td> 1957</td>\n",
        "      <td> 0</td>\n",
        "      <td> NLS195707090</td>\n",
        "      <td> ML1</td>\n",
        "      <td> NL</td>\n",
        "      <td> 1</td>\n",
        "      <td>  9</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "      <th>3</th>\n",
        "      <td> aaronha01</td>\n",
        "      <td> 1958</td>\n",
        "      <td> 0</td>\n",
        "      <td> ALS195807080</td>\n",
        "      <td> ML1</td>\n",
        "      <td> NL</td>\n",
        "      <td> 1</td>\n",
        "      <td>  9</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "      <th>4</th>\n",
        "      <td> aaronha01</td>\n",
        "      <td> 1959</td>\n",
        "      <td> 1</td>\n",
        "      <td> NLS195907070</td>\n",
        "      <td> ML1</td>\n",
        "      <td> NL</td>\n",
        "      <td> 1</td>\n",
        "      <td>  9</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "      <th>5</th>\n",
        "      <td> aaronha01</td>\n",
        "      <td> 1959</td>\n",
        "      <td> 2</td>\n",
        "      <td> NLS195908030</td>\n",
        "      <td> ML1</td>\n",
        "      <td> NL</td>\n",
        "      <td> 1</td>\n",
        "      <td>  9</td>\n",
        "    </tr>\n",
        "  </tbody>\n",
        "</table>\n",
        "</div>"
       ],
       "metadata": {},
       "output_type": "pyout",
       "prompt_number": 3,
       "text": [
        "    playerID  yearID  gameNum        gameID teamID lgID  GP  startingPos\n",
        "0  aaronha01    1955        0  NLS195507120    ML1   NL   1          NaN\n",
        "1  aaronha01    1956        0  ALS195607100    ML1   NL   1          NaN\n",
        "2  aaronha01    1957        0  NLS195707090    ML1   NL   1            9\n",
        "3  aaronha01    1958        0  ALS195807080    ML1   NL   1            9\n",
        "4  aaronha01    1959        1  NLS195907070    ML1   NL   1            9\n",
        "5  aaronha01    1959        2  NLS195908030    ML1   NL   1            9"
       ]
      }
     ],
     "prompt_number": 3
    },
    {
     "cell_type": "code",
     "collapsed": false,
     "input": [
      "db.tables.allstarfull.sample()"
     ],
     "language": "python",
     "metadata": {},
     "outputs": [
      {
       "html": [
        "<div style=\"max-height:1000px;max-width:1500px;overflow:auto;\">\n",
        "<table border=\"1\" class=\"dataframe\">\n",
        "  <thead>\n",
        "    <tr style=\"text-align: right;\">\n",
        "      <th></th>\n",
        "      <th>playerID</th>\n",
        "      <th>yearID</th>\n",
        "      <th>gameNum</th>\n",
        "      <th>gameID</th>\n",
        "      <th>teamID</th>\n",
        "      <th>lgID</th>\n",
        "      <th>GP</th>\n",
        "      <th>startingPos</th>\n",
        "    </tr>\n",
        "  </thead>\n",
        "  <tbody>\n",
        "    <tr>\n",
        "      <th>0</th>\n",
        "      <td> kellech01</td>\n",
        "      <td> 1941</td>\n",
        "      <td> 0</td>\n",
        "      <td> ALS194107080</td>\n",
        "      <td> NYA</td>\n",
        "      <td> AL</td>\n",
        "      <td> 1</td>\n",
        "      <td>NaN</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "      <th>1</th>\n",
        "      <td> burdele01</td>\n",
        "      <td> 1959</td>\n",
        "      <td> 1</td>\n",
        "      <td> NLS195907070</td>\n",
        "      <td> ML1</td>\n",
        "      <td> NL</td>\n",
        "      <td> 1</td>\n",
        "      <td>NaN</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "      <th>2</th>\n",
        "      <td> vaughar01</td>\n",
        "      <td> 1936</td>\n",
        "      <td> 0</td>\n",
        "      <td> NLS193607070</td>\n",
        "      <td> PIT</td>\n",
        "      <td> NL</td>\n",
        "      <td> 0</td>\n",
        "      <td>NaN</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "      <th>3</th>\n",
        "      <td> benchjo01</td>\n",
        "      <td> 1969</td>\n",
        "      <td> 0</td>\n",
        "      <td> ALS196907230</td>\n",
        "      <td> CIN</td>\n",
        "      <td> NL</td>\n",
        "      <td> 1</td>\n",
        "      <td>  2</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "      <th>4</th>\n",
        "      <td> reesepe01</td>\n",
        "      <td> 1951</td>\n",
        "      <td> 0</td>\n",
        "      <td> ALS195107100</td>\n",
        "      <td> BRO</td>\n",
        "      <td> NL</td>\n",
        "      <td> 1</td>\n",
        "      <td>NaN</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "      <th>5</th>\n",
        "      <td> glavito02</td>\n",
        "      <td> 2002</td>\n",
        "      <td> 0</td>\n",
        "      <td> NLS200207090</td>\n",
        "      <td> ATL</td>\n",
        "      <td> NL</td>\n",
        "      <td> 0</td>\n",
        "      <td>NaN</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "      <th>6</th>\n",
        "      <td> dimagjo01</td>\n",
        "      <td> 1939</td>\n",
        "      <td> 0</td>\n",
        "      <td> ALS193907110</td>\n",
        "      <td> NYA</td>\n",
        "      <td> AL</td>\n",
        "      <td> 1</td>\n",
        "      <td>  8</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "      <th>7</th>\n",
        "      <td> harrebu01</td>\n",
        "      <td> 1971</td>\n",
        "      <td> 0</td>\n",
        "      <td> ALS197107130</td>\n",
        "      <td> NYN</td>\n",
        "      <td> NL</td>\n",
        "      <td> 1</td>\n",
        "      <td>  6</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "      <th>8</th>\n",
        "      <td> truckvi01</td>\n",
        "      <td> 1949</td>\n",
        "      <td> 0</td>\n",
        "      <td> NLS194907120</td>\n",
        "      <td> DET</td>\n",
        "      <td> AL</td>\n",
        "      <td> 1</td>\n",
        "      <td>NaN</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "      <th>9</th>\n",
        "      <td> patekfr01</td>\n",
        "      <td> 1976</td>\n",
        "      <td> 0</td>\n",
        "      <td> NLS197607130</td>\n",
        "      <td> KCA</td>\n",
        "      <td> AL</td>\n",
        "      <td> 1</td>\n",
        "      <td>NaN</td>\n",
        "    </tr>\n",
        "  </tbody>\n",
        "</table>\n",
        "</div>"
       ],
       "metadata": {},
       "output_type": "pyout",
       "prompt_number": 4,
       "text": [
        "    playerID  yearID  gameNum        gameID teamID lgID  GP  startingPos\n",
        "0  kellech01    1941        0  ALS194107080    NYA   AL   1          NaN\n",
        "1  burdele01    1959        1  NLS195907070    ML1   NL   1          NaN\n",
        "2  vaughar01    1936        0  NLS193607070    PIT   NL   0          NaN\n",
        "3  benchjo01    1969        0  ALS196907230    CIN   NL   1            2\n",
        "4  reesepe01    1951        0  ALS195107100    BRO   NL   1          NaN\n",
        "5  glavito02    2002        0  NLS200207090    ATL   NL   0          NaN\n",
        "6  dimagjo01    1939        0  ALS193907110    NYA   AL   1            8\n",
        "7  harrebu01    1971        0  ALS197107130    NYN   NL   1            6\n",
        "8  truckvi01    1949        0  NLS194907120    DET   AL   1          NaN\n",
        "9  patekfr01    1976        0  NLS197607130    KCA   AL   1          NaN"
       ]
      }
     ],
     "prompt_number": 4
    },
    {
     "cell_type": "code",
     "collapsed": false,
     "input": [
      "db.tables.allstarfull.playerID"
     ],
     "language": "python",
     "metadata": {},
     "outputs": [
      {
       "html": [
        "<table>\n",
        "    <tr>\n",
        "        <th>Table</th>\n",
        "        <th>Name</th>\n",
        "        <th>Type</th>\n",
        "    </tr>\n",
        "    <tr>\n",
        "        <td>allstarfull</td>\n",
        "        <td>playerID</td>\n",
        "        <td>TEXT</td>\n",
        "    </tr>\n",
        "</table>"
       ],
       "metadata": {},
       "output_type": "pyout",
       "prompt_number": 5,
       "text": [
        "+-------------+----------+------+\n",
        "|    Table    |   Name   | Type |\n",
        "+-------------+----------+------+\n",
        "| allstarfull | playerID | TEXT |\n",
        "+-------------+----------+------+"
       ]
      }
     ],
     "prompt_number": 5
    },
    {
     "cell_type": "code",
     "collapsed": false,
     "input": [
      "db.tables.allstarfull.playerID.head()"
     ],
     "language": "python",
     "metadata": {},
     "outputs": [
      {
       "metadata": {},
       "output_type": "pyout",
       "prompt_number": 6,
       "text": [
        "0    aaronha01\n",
        "1    aaronha01\n",
        "2    aaronha01\n",
        "3    aaronha01\n",
        "4    aaronha01\n",
        "5    aaronha01\n",
        "Name: playerID, dtype: object"
       ]
      }
     ],
     "prompt_number": 6
    },
    {
     "cell_type": "code",
     "collapsed": false,
     "input": [
      "db.tables.allstarfull.playerID.unique().count()"
     ],
     "language": "python",
     "metadata": {},
     "outputs": [
      {
       "metadata": {},
       "output_type": "pyout",
       "prompt_number": 7,
       "text": [
        "1637"
       ]
      }
     ],
     "prompt_number": 7
    },
    {
     "cell_type": "code",
     "collapsed": false,
     "input": [
      "db.find_column(\"*player*\")"
     ],
     "language": "python",
     "metadata": {},
     "outputs": [
      {
       "html": [
        "<table>\n",
        "    <tr>\n",
        "        <th>Table</th>\n",
        "        <th>Column Name</th>\n",
        "        <th>Type</th>\n",
        "    </tr>\n",
        "    <tr>\n",
        "        <td>allstarfull</td>\n",
        "        <td>playerID</td>\n",
        "        <td>TEXT</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "        <td>appearances</td>\n",
        "        <td>playerID</td>\n",
        "        <td>TEXT</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "        <td>awardsplayers</td>\n",
        "        <td>playerID</td>\n",
        "        <td>TEXT</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "        <td>awardsshareplayers</td>\n",
        "        <td>playerID</td>\n",
        "        <td>TEXT</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "        <td>battingpost</td>\n",
        "        <td>playerID</td>\n",
        "        <td>TEXT</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "        <td>fielding</td>\n",
        "        <td>playerID</td>\n",
        "        <td>TEXT</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "        <td>fieldingof</td>\n",
        "        <td>playerID</td>\n",
        "        <td>TEXT</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "        <td>fieldingpost</td>\n",
        "        <td>playerID</td>\n",
        "        <td>TEXT</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "        <td>master</td>\n",
        "        <td>playerID</td>\n",
        "        <td>TEXT</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "        <td>pitching</td>\n",
        "        <td>playerID</td>\n",
        "        <td>TEXT</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "        <td>pitchingpost</td>\n",
        "        <td>playerID</td>\n",
        "        <td>TEXT</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "        <td>salaries</td>\n",
        "        <td>playerID</td>\n",
        "        <td>TEXT</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "        <td>schoolsplayers</td>\n",
        "        <td>playerID</td>\n",
        "        <td>TEXT</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "        <td>tmp_batting</td>\n",
        "        <td>playerID</td>\n",
        "        <td>TEXT</td>\n",
        "    </tr>\n",
        "</table>"
       ],
       "metadata": {},
       "output_type": "pyout",
       "prompt_number": 8,
       "text": [
        "+--------------------+-------------+------+\n",
        "| Table              | Column Name | Type |\n",
        "+--------------------+-------------+------+\n",
        "| allstarfull        |   playerID  | TEXT |\n",
        "| appearances        |   playerID  | TEXT |\n",
        "| awardsplayers      |   playerID  | TEXT |\n",
        "| awardsshareplayers |   playerID  | TEXT |\n",
        "| battingpost        |   playerID  | TEXT |\n",
        "| fielding           |   playerID  | TEXT |\n",
        "| fieldingof         |   playerID  | TEXT |\n",
        "| fieldingpost       |   playerID  | TEXT |\n",
        "| master             |   playerID  | TEXT |\n",
        "| pitching           |   playerID  | TEXT |\n",
        "| pitchingpost       |   playerID  | TEXT |\n",
        "| salaries           |   playerID  | TEXT |\n",
        "| schoolsplayers     |   playerID  | TEXT |\n",
        "| tmp_batting        |   playerID  | TEXT |\n",
        "+--------------------+-------------+------+"
       ]
      }
     ],
     "prompt_number": 8
    },
    {
     "cell_type": "code",
     "collapsed": false,
     "input": [
      "db.find_column(\"*ID*\")"
     ],
     "language": "python",
     "metadata": {},
     "outputs": [
      {
       "html": [
        "<table>\n",
        "    <tr>\n",
        "        <th>Table</th>\n",
        "        <th>Column Name</th>\n",
        "        <th>Type</th>\n",
        "    </tr>\n",
        "    <tr>\n",
        "        <td>allstarfull</td>\n",
        "        <td>lgID</td>\n",
        "        <td>TEXT</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "        <td>allstarfull</td>\n",
        "        <td>gameID</td>\n",
        "        <td>TEXT</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "        <td>allstarfull</td>\n",
        "        <td>playerID</td>\n",
        "        <td>TEXT</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "        <td>allstarfull</td>\n",
        "        <td>teamID</td>\n",
        "        <td>TEXT</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "        <td>allstarfull</td>\n",
        "        <td>yearID</td>\n",
        "        <td>INTEGER</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "        <td>appearances</td>\n",
        "        <td>playerID</td>\n",
        "        <td>TEXT</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "        <td>appearances</td>\n",
        "        <td>teamID</td>\n",
        "        <td>TEXT</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "        <td>appearances</td>\n",
        "        <td>yearID</td>\n",
        "        <td>INTEGER</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "        <td>appearances</td>\n",
        "        <td>lgID</td>\n",
        "        <td>TEXT</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "        <td>awardsmanagers</td>\n",
        "        <td>lgID</td>\n",
        "        <td>TEXT</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "        <td>awardsmanagers</td>\n",
        "        <td>managerID</td>\n",
        "        <td>TEXT</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "        <td>awardsmanagers</td>\n",
        "        <td>yearID</td>\n",
        "        <td>INTEGER</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "        <td>awardsmanagers</td>\n",
        "        <td>awardID</td>\n",
        "        <td>TEXT</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "        <td>awardsplayers</td>\n",
        "        <td>lgID</td>\n",
        "        <td>TEXT</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "        <td>awardsplayers</td>\n",
        "        <td>playerID</td>\n",
        "        <td>TEXT</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "        <td>awardsplayers</td>\n",
        "        <td>yearID</td>\n",
        "        <td>INTEGER</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "        <td>awardsplayers</td>\n",
        "        <td>awardID</td>\n",
        "        <td>TEXT</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "        <td>awardssharemanagers</td>\n",
        "        <td>lgID</td>\n",
        "        <td>TEXT</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "        <td>awardssharemanagers</td>\n",
        "        <td>managerID</td>\n",
        "        <td>TEXT</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "        <td>awardssharemanagers</td>\n",
        "        <td>yearID</td>\n",
        "        <td>INTEGER</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "        <td>awardssharemanagers</td>\n",
        "        <td>awardID</td>\n",
        "        <td>TEXT</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "        <td>awardsshareplayers</td>\n",
        "        <td>lgID</td>\n",
        "        <td>TEXT</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "        <td>awardsshareplayers</td>\n",
        "        <td>playerID</td>\n",
        "        <td>TEXT</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "        <td>awardsshareplayers</td>\n",
        "        <td>yearID</td>\n",
        "        <td>INTEGER</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "        <td>awardsshareplayers</td>\n",
        "        <td>awardID</td>\n",
        "        <td>TEXT</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "        <td>battingpost</td>\n",
        "        <td>playerID</td>\n",
        "        <td>TEXT</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "        <td>battingpost</td>\n",
        "        <td>teamID</td>\n",
        "        <td>TEXT</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "        <td>battingpost</td>\n",
        "        <td>yearID</td>\n",
        "        <td>INTEGER</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "        <td>battingpost</td>\n",
        "        <td>GIDP</td>\n",
        "        <td>INTEGER</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "        <td>battingpost</td>\n",
        "        <td>lgID</td>\n",
        "        <td>TEXT</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "        <td>fielding</td>\n",
        "        <td>playerID</td>\n",
        "        <td>TEXT</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "        <td>fielding</td>\n",
        "        <td>teamID</td>\n",
        "        <td>TEXT</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "        <td>fielding</td>\n",
        "        <td>yearID</td>\n",
        "        <td>INTEGER</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "        <td>fielding</td>\n",
        "        <td>lgID</td>\n",
        "        <td>TEXT</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "        <td>fieldingof</td>\n",
        "        <td>playerID</td>\n",
        "        <td>TEXT</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "        <td>fieldingof</td>\n",
        "        <td>yearID</td>\n",
        "        <td>INTEGER</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "        <td>fieldingpost</td>\n",
        "        <td>lgID</td>\n",
        "        <td>TEXT</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "        <td>fieldingpost</td>\n",
        "        <td>playerID</td>\n",
        "        <td>TEXT</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "        <td>fieldingpost</td>\n",
        "        <td>teamID</td>\n",
        "        <td>TEXT</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "        <td>fieldingpost</td>\n",
        "        <td>yearID</td>\n",
        "        <td>INTEGER</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "        <td>halloffame</td>\n",
        "        <td>hofID</td>\n",
        "        <td>TEXT</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "        <td>hofold</td>\n",
        "        <td>hofID</td>\n",
        "        <td>TEXT</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "        <td>managers</td>\n",
        "        <td>lgID</td>\n",
        "        <td>TEXT</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "        <td>managers</td>\n",
        "        <td>teamID</td>\n",
        "        <td>TEXT</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "        <td>managers</td>\n",
        "        <td>managerID</td>\n",
        "        <td>TEXT</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "        <td>managers</td>\n",
        "        <td>yearID</td>\n",
        "        <td>INTEGER</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "        <td>managershalf</td>\n",
        "        <td>lgID</td>\n",
        "        <td>TEXT</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "        <td>managershalf</td>\n",
        "        <td>teamID</td>\n",
        "        <td>TEXT</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "        <td>managershalf</td>\n",
        "        <td>managerID</td>\n",
        "        <td>TEXT</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "        <td>managershalf</td>\n",
        "        <td>yearID</td>\n",
        "        <td>INTEGER</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "        <td>master</td>\n",
        "        <td>lahman40ID</td>\n",
        "        <td>TEXT</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "        <td>master</td>\n",
        "        <td>bbrefID</td>\n",
        "        <td>TEXT</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "        <td>master</td>\n",
        "        <td>retroID</td>\n",
        "        <td>TEXT</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "        <td>master</td>\n",
        "        <td>lahmanID</td>\n",
        "        <td>INTEGER</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "        <td>master</td>\n",
        "        <td>playerID</td>\n",
        "        <td>TEXT</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "        <td>master</td>\n",
        "        <td>hofID</td>\n",
        "        <td>TEXT</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "        <td>master</td>\n",
        "        <td>holtzID</td>\n",
        "        <td>TEXT</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "        <td>master</td>\n",
        "        <td>managerID</td>\n",
        "        <td>TEXT</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "        <td>master</td>\n",
        "        <td>lahman45ID</td>\n",
        "        <td>TEXT</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "        <td>pitching</td>\n",
        "        <td>playerID</td>\n",
        "        <td>TEXT</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "        <td>pitching</td>\n",
        "        <td>teamID</td>\n",
        "        <td>TEXT</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "        <td>pitching</td>\n",
        "        <td>yearID</td>\n",
        "        <td>INTEGER</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "        <td>pitching</td>\n",
        "        <td>GIDP</td>\n",
        "        <td>INTEGER</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "        <td>pitching</td>\n",
        "        <td>lgID</td>\n",
        "        <td>TEXT</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "        <td>pitchingpost</td>\n",
        "        <td>playerID</td>\n",
        "        <td>TEXT</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "        <td>pitchingpost</td>\n",
        "        <td>teamID</td>\n",
        "        <td>TEXT</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "        <td>pitchingpost</td>\n",
        "        <td>yearID</td>\n",
        "        <td>INTEGER</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "        <td>pitchingpost</td>\n",
        "        <td>GIDP</td>\n",
        "        <td>INTEGER</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "        <td>pitchingpost</td>\n",
        "        <td>lgID</td>\n",
        "        <td>TEXT</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "        <td>salaries</td>\n",
        "        <td>lgID</td>\n",
        "        <td>TEXT</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "        <td>salaries</td>\n",
        "        <td>playerID</td>\n",
        "        <td>TEXT</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "        <td>salaries</td>\n",
        "        <td>teamID</td>\n",
        "        <td>TEXT</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "        <td>salaries</td>\n",
        "        <td>yearID</td>\n",
        "        <td>INTEGER</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "        <td>schools</td>\n",
        "        <td>schoolID</td>\n",
        "        <td>TEXT</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "        <td>schoolsplayers</td>\n",
        "        <td>schoolID</td>\n",
        "        <td>TEXT</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "        <td>schoolsplayers</td>\n",
        "        <td>playerID</td>\n",
        "        <td>TEXT</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "        <td>seriespost</td>\n",
        "        <td>lgIDwinner</td>\n",
        "        <td>TEXT</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "        <td>seriespost</td>\n",
        "        <td>lgIDloser</td>\n",
        "        <td>TEXT</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "        <td>seriespost</td>\n",
        "        <td>teamIDwinner</td>\n",
        "        <td>TEXT</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "        <td>seriespost</td>\n",
        "        <td>yearID</td>\n",
        "        <td>INTEGER</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "        <td>seriespost</td>\n",
        "        <td>teamIDloser</td>\n",
        "        <td>TEXT</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "        <td>teams</td>\n",
        "        <td>teamID</td>\n",
        "        <td>TEXT</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "        <td>teams</td>\n",
        "        <td>teamIDBR</td>\n",
        "        <td>TEXT</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "        <td>teams</td>\n",
        "        <td>teamIDretro</td>\n",
        "        <td>TEXT</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "        <td>teams</td>\n",
        "        <td>yearID</td>\n",
        "        <td>INTEGER</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "        <td>teams</td>\n",
        "        <td>teamIDlahman45</td>\n",
        "        <td>TEXT</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "        <td>teams</td>\n",
        "        <td>lgID</td>\n",
        "        <td>TEXT</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "        <td>teams</td>\n",
        "        <td>franchID</td>\n",
        "        <td>TEXT</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "        <td>teams</td>\n",
        "        <td>divID</td>\n",
        "        <td>TEXT</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "        <td>teamsfranchises</td>\n",
        "        <td>franchID</td>\n",
        "        <td>TEXT</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "        <td>teamshalf</td>\n",
        "        <td>lgID</td>\n",
        "        <td>TEXT</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "        <td>teamshalf</td>\n",
        "        <td>divID</td>\n",
        "        <td>TEXT</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "        <td>teamshalf</td>\n",
        "        <td>teamID</td>\n",
        "        <td>TEXT</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "        <td>teamshalf</td>\n",
        "        <td>yearID</td>\n",
        "        <td>INTEGER</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "        <td>tmp_batting</td>\n",
        "        <td>playerID</td>\n",
        "        <td>TEXT</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "        <td>tmp_batting</td>\n",
        "        <td>teamID</td>\n",
        "        <td>TEXT</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "        <td>tmp_batting</td>\n",
        "        <td>yearID</td>\n",
        "        <td>INTEGER</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "        <td>tmp_batting</td>\n",
        "        <td>GIDP</td>\n",
        "        <td>INTEGER</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "        <td>tmp_batting</td>\n",
        "        <td>lgID</td>\n",
        "        <td>TEXT</td>\n",
        "    </tr>\n",
        "</table>"
       ],
       "metadata": {},
       "output_type": "pyout",
       "prompt_number": 9,
       "text": [
        "+---------------------+----------------+---------+\n",
        "| Table               |  Column Name   | Type    |\n",
        "+---------------------+----------------+---------+\n",
        "| allstarfull         |      lgID      | TEXT    |\n",
        "| allstarfull         |     gameID     | TEXT    |\n",
        "| allstarfull         |    playerID    | TEXT    |\n",
        "| allstarfull         |     teamID     | TEXT    |\n",
        "| allstarfull         |     yearID     | INTEGER |\n",
        "| appearances         |    playerID    | TEXT    |\n",
        "| appearances         |     teamID     | TEXT    |\n",
        "| appearances         |     yearID     | INTEGER |\n",
        "| appearances         |      lgID      | TEXT    |\n",
        "| awardsmanagers      |      lgID      | TEXT    |\n",
        "| awardsmanagers      |   managerID    | TEXT    |\n",
        "| awardsmanagers      |     yearID     | INTEGER |\n",
        "| awardsmanagers      |    awardID     | TEXT    |\n",
        "| awardsplayers       |      lgID      | TEXT    |\n",
        "| awardsplayers       |    playerID    | TEXT    |\n",
        "| awardsplayers       |     yearID     | INTEGER |\n",
        "| awardsplayers       |    awardID     | TEXT    |\n",
        "| awardssharemanagers |      lgID      | TEXT    |\n",
        "| awardssharemanagers |   managerID    | TEXT    |\n",
        "| awardssharemanagers |     yearID     | INTEGER |\n",
        "| awardssharemanagers |    awardID     | TEXT    |\n",
        "| awardsshareplayers  |      lgID      | TEXT    |\n",
        "| awardsshareplayers  |    playerID    | TEXT    |\n",
        "| awardsshareplayers  |     yearID     | INTEGER |\n",
        "| awardsshareplayers  |    awardID     | TEXT    |\n",
        "| battingpost         |    playerID    | TEXT    |\n",
        "| battingpost         |     teamID     | TEXT    |\n",
        "| battingpost         |     yearID     | INTEGER |\n",
        "| battingpost         |      GIDP      | INTEGER |\n",
        "| battingpost         |      lgID      | TEXT    |\n",
        "| fielding            |    playerID    | TEXT    |\n",
        "| fielding            |     teamID     | TEXT    |\n",
        "| fielding            |     yearID     | INTEGER |\n",
        "| fielding            |      lgID      | TEXT    |\n",
        "| fieldingof          |    playerID    | TEXT    |\n",
        "| fieldingof          |     yearID     | INTEGER |\n",
        "| fieldingpost        |      lgID      | TEXT    |\n",
        "| fieldingpost        |    playerID    | TEXT    |\n",
        "| fieldingpost        |     teamID     | TEXT    |\n",
        "| fieldingpost        |     yearID     | INTEGER |\n",
        "| halloffame          |     hofID      | TEXT    |\n",
        "| hofold              |     hofID      | TEXT    |\n",
        "| managers            |      lgID      | TEXT    |\n",
        "| managers            |     teamID     | TEXT    |\n",
        "| managers            |   managerID    | TEXT    |\n",
        "| managers            |     yearID     | INTEGER |\n",
        "| managershalf        |      lgID      | TEXT    |\n",
        "| managershalf        |     teamID     | TEXT    |\n",
        "| managershalf        |   managerID    | TEXT    |\n",
        "| managershalf        |     yearID     | INTEGER |\n",
        "| master              |   lahman40ID   | TEXT    |\n",
        "| master              |    bbrefID     | TEXT    |\n",
        "| master              |    retroID     | TEXT    |\n",
        "| master              |    lahmanID    | INTEGER |\n",
        "| master              |    playerID    | TEXT    |\n",
        "| master              |     hofID      | TEXT    |\n",
        "| master              |    holtzID     | TEXT    |\n",
        "| master              |   managerID    | TEXT    |\n",
        "| master              |   lahman45ID   | TEXT    |\n",
        "| pitching            |    playerID    | TEXT    |\n",
        "| pitching            |     teamID     | TEXT    |\n",
        "| pitching            |     yearID     | INTEGER |\n",
        "| pitching            |      GIDP      | INTEGER |\n",
        "| pitching            |      lgID      | TEXT    |\n",
        "| pitchingpost        |    playerID    | TEXT    |\n",
        "| pitchingpost        |     teamID     | TEXT    |\n",
        "| pitchingpost        |     yearID     | INTEGER |\n",
        "| pitchingpost        |      GIDP      | INTEGER |\n",
        "| pitchingpost        |      lgID      | TEXT    |\n",
        "| salaries            |      lgID      | TEXT    |\n",
        "| salaries            |    playerID    | TEXT    |\n",
        "| salaries            |     teamID     | TEXT    |\n",
        "| salaries            |     yearID     | INTEGER |\n",
        "| schools             |    schoolID    | TEXT    |\n",
        "| schoolsplayers      |    schoolID    | TEXT    |\n",
        "| schoolsplayers      |    playerID    | TEXT    |\n",
        "| seriespost          |   lgIDwinner   | TEXT    |\n",
        "| seriespost          |   lgIDloser    | TEXT    |\n",
        "| seriespost          |  teamIDwinner  | TEXT    |\n",
        "| seriespost          |     yearID     | INTEGER |\n",
        "| seriespost          |  teamIDloser   | TEXT    |\n",
        "| teams               |     teamID     | TEXT    |\n",
        "| teams               |    teamIDBR    | TEXT    |\n",
        "| teams               |  teamIDretro   | TEXT    |\n",
        "| teams               |     yearID     | INTEGER |\n",
        "| teams               | teamIDlahman45 | TEXT    |\n",
        "| teams               |      lgID      | TEXT    |\n",
        "| teams               |    franchID    | TEXT    |\n",
        "| teams               |     divID      | TEXT    |\n",
        "| teamsfranchises     |    franchID    | TEXT    |\n",
        "| teamshalf           |      lgID      | TEXT    |\n",
        "| teamshalf           |     divID      | TEXT    |\n",
        "| teamshalf           |     teamID     | TEXT    |\n",
        "| teamshalf           |     yearID     | INTEGER |\n",
        "| tmp_batting         |    playerID    | TEXT    |\n",
        "| tmp_batting         |     teamID     | TEXT    |\n",
        "| tmp_batting         |     yearID     | INTEGER |\n",
        "| tmp_batting         |      GIDP      | INTEGER |\n",
        "| tmp_batting         |      lgID      | TEXT    |\n",
        "+---------------------+----------------+---------+"
       ]
      }
     ],
     "prompt_number": 9
    },
    {
     "cell_type": "code",
     "collapsed": false,
     "input": [
      "db.find_column(\"HR\")"
     ],
     "language": "python",
     "metadata": {},
     "outputs": [
      {
       "html": [
        "<table>\n",
        "    <tr>\n",
        "        <th>Table</th>\n",
        "        <th>Column Name</th>\n",
        "        <th>Type</th>\n",
        "    </tr>\n",
        "    <tr>\n",
        "        <td>battingpost</td>\n",
        "        <td>HR</td>\n",
        "        <td>INTEGER</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "        <td>pitching</td>\n",
        "        <td>HR</td>\n",
        "        <td>INTEGER</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "        <td>pitchingpost</td>\n",
        "        <td>HR</td>\n",
        "        <td>INTEGER</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "        <td>teams</td>\n",
        "        <td>HR</td>\n",
        "        <td>INTEGER</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "        <td>tmp_batting</td>\n",
        "        <td>HR</td>\n",
        "        <td>INTEGER</td>\n",
        "    </tr>\n",
        "</table>"
       ],
       "metadata": {},
       "output_type": "pyout",
       "prompt_number": 10,
       "text": [
        "+--------------+-------------+---------+\n",
        "| Table        | Column Name | Type    |\n",
        "+--------------+-------------+---------+\n",
        "| battingpost  |      HR     | INTEGER |\n",
        "| pitching     |      HR     | INTEGER |\n",
        "| pitchingpost |      HR     | INTEGER |\n",
        "| teams        |      HR     | INTEGER |\n",
        "| tmp_batting  |      HR     | INTEGER |\n",
        "+--------------+-------------+---------+"
       ]
      }
     ],
     "prompt_number": 10
    },
    {
     "cell_type": "code",
     "collapsed": false,
     "input": [
      "db.find_column(\"HR\", \"INTEGER\")"
     ],
     "language": "python",
     "metadata": {},
     "outputs": [
      {
       "html": [
        "<table>\n",
        "    <tr>\n",
        "        <th>Table</th>\n",
        "        <th>Column Name</th>\n",
        "        <th>Type</th>\n",
        "    </tr>\n",
        "    <tr>\n",
        "        <td>battingpost</td>\n",
        "        <td>HR</td>\n",
        "        <td>INTEGER</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "        <td>pitching</td>\n",
        "        <td>HR</td>\n",
        "        <td>INTEGER</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "        <td>pitchingpost</td>\n",
        "        <td>HR</td>\n",
        "        <td>INTEGER</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "        <td>teams</td>\n",
        "        <td>HR</td>\n",
        "        <td>INTEGER</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "        <td>tmp_batting</td>\n",
        "        <td>HR</td>\n",
        "        <td>INTEGER</td>\n",
        "    </tr>\n",
        "</table>"
       ],
       "metadata": {},
       "output_type": "pyout",
       "prompt_number": 11,
       "text": [
        "+--------------+-------------+---------+\n",
        "| Table        | Column Name | Type    |\n",
        "+--------------+-------------+---------+\n",
        "| battingpost  |      HR     | INTEGER |\n",
        "| pitching     |      HR     | INTEGER |\n",
        "| pitchingpost |      HR     | INTEGER |\n",
        "| teams        |      HR     | INTEGER |\n",
        "| tmp_batting  |      HR     | INTEGER |\n",
        "+--------------+-------------+---------+"
       ]
      }
     ],
     "prompt_number": 11
    },
    {
     "cell_type": "code",
     "collapsed": false,
     "input": [
      "db.find_column(\"*\", \"INTEGER\")"
     ],
     "language": "python",
     "metadata": {},
     "outputs": [
      {
       "html": [
        "<table>\n",
        "    <tr>\n",
        "        <th>Table</th>\n",
        "        <th>Column Name</th>\n",
        "        <th>Type</th>\n",
        "    </tr>\n",
        "    <tr>\n",
        "        <td>allstarfull</td>\n",
        "        <td>GP</td>\n",
        "        <td>INTEGER</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "        <td>allstarfull</td>\n",
        "        <td>yearID</td>\n",
        "        <td>INTEGER</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "        <td>allstarfull</td>\n",
        "        <td>startingPos</td>\n",
        "        <td>INTEGER</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "        <td>allstarfull</td>\n",
        "        <td>gameNum</td>\n",
        "        <td>INTEGER</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "        <td>appearances</td>\n",
        "        <td>G_cf</td>\n",
        "        <td>INTEGER</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "        <td>appearances</td>\n",
        "        <td>G_all</td>\n",
        "        <td>INTEGER</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "        <td>appearances</td>\n",
        "        <td>G_2b</td>\n",
        "        <td>INTEGER</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "        <td>appearances</td>\n",
        "        <td>G_batting</td>\n",
        "        <td>INTEGER</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "        <td>appearances</td>\n",
        "        <td>G_p</td>\n",
        "        <td>INTEGER</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "        <td>appearances</td>\n",
        "        <td>G_ss</td>\n",
        "        <td>INTEGER</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "        <td>appearances</td>\n",
        "        <td>G_of</td>\n",
        "        <td>INTEGER</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "        <td>appearances</td>\n",
        "        <td>G_c</td>\n",
        "        <td>INTEGER</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "        <td>appearances</td>\n",
        "        <td>G_dh</td>\n",
        "        <td>INTEGER</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "        <td>appearances</td>\n",
        "        <td>yearID</td>\n",
        "        <td>INTEGER</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "        <td>appearances</td>\n",
        "        <td>G_3b</td>\n",
        "        <td>INTEGER</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "        <td>appearances</td>\n",
        "        <td>G_rf</td>\n",
        "        <td>INTEGER</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "        <td>appearances</td>\n",
        "        <td>G_1b</td>\n",
        "        <td>INTEGER</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "        <td>appearances</td>\n",
        "        <td>G_lf</td>\n",
        "        <td>INTEGER</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "        <td>appearances</td>\n",
        "        <td>G_defense</td>\n",
        "        <td>INTEGER</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "        <td>appearances</td>\n",
        "        <td>G_ph</td>\n",
        "        <td>INTEGER</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "        <td>appearances</td>\n",
        "        <td>G_pr</td>\n",
        "        <td>INTEGER</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "        <td>awardsmanagers</td>\n",
        "        <td>yearID</td>\n",
        "        <td>INTEGER</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "        <td>awardsplayers</td>\n",
        "        <td>yearID</td>\n",
        "        <td>INTEGER</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "        <td>awardssharemanagers</td>\n",
        "        <td>votesFirst</td>\n",
        "        <td>INTEGER</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "        <td>awardssharemanagers</td>\n",
        "        <td>pointsWon</td>\n",
        "        <td>INTEGER</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "        <td>awardssharemanagers</td>\n",
        "        <td>yearID</td>\n",
        "        <td>INTEGER</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "        <td>awardssharemanagers</td>\n",
        "        <td>pointsMax</td>\n",
        "        <td>INTEGER</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "        <td>awardsshareplayers</td>\n",
        "        <td>yearID</td>\n",
        "        <td>INTEGER</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "        <td>awardsshareplayers</td>\n",
        "        <td>pointsMax</td>\n",
        "        <td>INTEGER</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "        <td>battingpost</td>\n",
        "        <td>RBI</td>\n",
        "        <td>INTEGER</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "        <td>battingpost</td>\n",
        "        <td>BB</td>\n",
        "        <td>INTEGER</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "        <td>battingpost</td>\n",
        "        <td>HR</td>\n",
        "        <td>INTEGER</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "        <td>battingpost</td>\n",
        "        <td>IBB</td>\n",
        "        <td>INTEGER</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "        <td>battingpost</td>\n",
        "        <td>3B</td>\n",
        "        <td>INTEGER</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "        <td>battingpost</td>\n",
        "        <td>HBP</td>\n",
        "        <td>INTEGER</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "        <td>battingpost</td>\n",
        "        <td>AB</td>\n",
        "        <td>INTEGER</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "        <td>battingpost</td>\n",
        "        <td>G</td>\n",
        "        <td>INTEGER</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "        <td>battingpost</td>\n",
        "        <td>H</td>\n",
        "        <td>INTEGER</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "        <td>battingpost</td>\n",
        "        <td>yearID</td>\n",
        "        <td>INTEGER</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "        <td>battingpost</td>\n",
        "        <td>R</td>\n",
        "        <td>INTEGER</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "        <td>battingpost</td>\n",
        "        <td>2B</td>\n",
        "        <td>INTEGER</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "        <td>battingpost</td>\n",
        "        <td>CS</td>\n",
        "        <td>INTEGER</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "        <td>battingpost</td>\n",
        "        <td>GIDP</td>\n",
        "        <td>INTEGER</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "        <td>battingpost</td>\n",
        "        <td>SF</td>\n",
        "        <td>INTEGER</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "        <td>battingpost</td>\n",
        "        <td>SH</td>\n",
        "        <td>INTEGER</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "        <td>battingpost</td>\n",
        "        <td>SO</td>\n",
        "        <td>INTEGER</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "        <td>battingpost</td>\n",
        "        <td>SB</td>\n",
        "        <td>INTEGER</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "        <td>fielding</td>\n",
        "        <td>WP</td>\n",
        "        <td>INTEGER</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "        <td>fielding</td>\n",
        "        <td>E</td>\n",
        "        <td>INTEGER</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "        <td>fielding</td>\n",
        "        <td>stint</td>\n",
        "        <td>INTEGER</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "        <td>fielding</td>\n",
        "        <td>DP</td>\n",
        "        <td>INTEGER</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "        <td>fielding</td>\n",
        "        <td>PB</td>\n",
        "        <td>INTEGER</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "        <td>fielding</td>\n",
        "        <td>PO</td>\n",
        "        <td>INTEGER</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "        <td>fielding</td>\n",
        "        <td>A</td>\n",
        "        <td>INTEGER</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "        <td>fielding</td>\n",
        "        <td>GS</td>\n",
        "        <td>INTEGER</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "        <td>fielding</td>\n",
        "        <td>G</td>\n",
        "        <td>INTEGER</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "        <td>fielding</td>\n",
        "        <td>yearID</td>\n",
        "        <td>INTEGER</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "        <td>fielding</td>\n",
        "        <td>CS</td>\n",
        "        <td>INTEGER</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "        <td>fielding</td>\n",
        "        <td>InnOuts</td>\n",
        "        <td>INTEGER</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "        <td>fielding</td>\n",
        "        <td>SB</td>\n",
        "        <td>INTEGER</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "        <td>fieldingof</td>\n",
        "        <td>Gcf</td>\n",
        "        <td>INTEGER</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "        <td>fieldingof</td>\n",
        "        <td>Glf</td>\n",
        "        <td>INTEGER</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "        <td>fieldingof</td>\n",
        "        <td>Grf</td>\n",
        "        <td>INTEGER</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "        <td>fieldingof</td>\n",
        "        <td>yearID</td>\n",
        "        <td>INTEGER</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "        <td>fieldingof</td>\n",
        "        <td>stint</td>\n",
        "        <td>INTEGER</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "        <td>fieldingpost</td>\n",
        "        <td>A</td>\n",
        "        <td>INTEGER</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "        <td>fieldingpost</td>\n",
        "        <td>G</td>\n",
        "        <td>INTEGER</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "        <td>fieldingpost</td>\n",
        "        <td>TP</td>\n",
        "        <td>INTEGER</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "        <td>fieldingpost</td>\n",
        "        <td>PB</td>\n",
        "        <td>INTEGER</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "        <td>fieldingpost</td>\n",
        "        <td>InnOuts</td>\n",
        "        <td>INTEGER</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "        <td>fieldingpost</td>\n",
        "        <td>yearID</td>\n",
        "        <td>INTEGER</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "        <td>fieldingpost</td>\n",
        "        <td>PO</td>\n",
        "        <td>INTEGER</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "        <td>fieldingpost</td>\n",
        "        <td>SB</td>\n",
        "        <td>INTEGER</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "        <td>fieldingpost</td>\n",
        "        <td>CS</td>\n",
        "        <td>INTEGER</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "        <td>fieldingpost</td>\n",
        "        <td>GS</td>\n",
        "        <td>INTEGER</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "        <td>fieldingpost</td>\n",
        "        <td>E</td>\n",
        "        <td>INTEGER</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "        <td>fieldingpost</td>\n",
        "        <td>DP</td>\n",
        "        <td>INTEGER</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "        <td>halloffame</td>\n",
        "        <td>votes</td>\n",
        "        <td>INTEGER</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "        <td>halloffame</td>\n",
        "        <td>needed</td>\n",
        "        <td>INTEGER</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "        <td>halloffame</td>\n",
        "        <td>yearid</td>\n",
        "        <td>INTEGER</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "        <td>halloffame</td>\n",
        "        <td>ballots</td>\n",
        "        <td>INTEGER</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "        <td>hofold</td>\n",
        "        <td>votes</td>\n",
        "        <td>INTEGER</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "        <td>hofold</td>\n",
        "        <td>yearid</td>\n",
        "        <td>INTEGER</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "        <td>hofold</td>\n",
        "        <td>ballots</td>\n",
        "        <td>INTEGER</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "        <td>managers</td>\n",
        "        <td>G</td>\n",
        "        <td>INTEGER</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "        <td>managers</td>\n",
        "        <td>rank</td>\n",
        "        <td>INTEGER</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "        <td>managers</td>\n",
        "        <td>W</td>\n",
        "        <td>INTEGER</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "        <td>managers</td>\n",
        "        <td>yearID</td>\n",
        "        <td>INTEGER</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "        <td>managers</td>\n",
        "        <td>inseason</td>\n",
        "        <td>INTEGER</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "        <td>managers</td>\n",
        "        <td>L</td>\n",
        "        <td>INTEGER</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "        <td>managershalf</td>\n",
        "        <td>G</td>\n",
        "        <td>INTEGER</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "        <td>managershalf</td>\n",
        "        <td>rank</td>\n",
        "        <td>INTEGER</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "        <td>managershalf</td>\n",
        "        <td>W</td>\n",
        "        <td>INTEGER</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "        <td>managershalf</td>\n",
        "        <td>yearID</td>\n",
        "        <td>INTEGER</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "        <td>managershalf</td>\n",
        "        <td>inseason</td>\n",
        "        <td>INTEGER</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "        <td>managershalf</td>\n",
        "        <td>half</td>\n",
        "        <td>INTEGER</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "        <td>managershalf</td>\n",
        "        <td>L</td>\n",
        "        <td>INTEGER</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "        <td>master</td>\n",
        "        <td>weight</td>\n",
        "        <td>INTEGER</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "        <td>master</td>\n",
        "        <td>lahmanID</td>\n",
        "        <td>INTEGER</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "        <td>master</td>\n",
        "        <td>birthMonth</td>\n",
        "        <td>INTEGER</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "        <td>master</td>\n",
        "        <td>deathMonth</td>\n",
        "        <td>INTEGER</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "        <td>master</td>\n",
        "        <td>deathYear</td>\n",
        "        <td>INTEGER</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "        <td>master</td>\n",
        "        <td>birthYear</td>\n",
        "        <td>INTEGER</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "        <td>master</td>\n",
        "        <td>birthDay</td>\n",
        "        <td>INTEGER</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "        <td>master</td>\n",
        "        <td>deathDay</td>\n",
        "        <td>INTEGER</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "        <td>pitching</td>\n",
        "        <td>BB</td>\n",
        "        <td>INTEGER</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "        <td>pitching</td>\n",
        "        <td>HR</td>\n",
        "        <td>INTEGER</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "        <td>pitching</td>\n",
        "        <td>IBB</td>\n",
        "        <td>INTEGER</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "        <td>pitching</td>\n",
        "        <td>IPouts</td>\n",
        "        <td>INTEGER</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "        <td>pitching</td>\n",
        "        <td>BK</td>\n",
        "        <td>INTEGER</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "        <td>pitching</td>\n",
        "        <td>WP</td>\n",
        "        <td>INTEGER</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "        <td>pitching</td>\n",
        "        <td>stint</td>\n",
        "        <td>INTEGER</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "        <td>pitching</td>\n",
        "        <td>HBP</td>\n",
        "        <td>INTEGER</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "        <td>pitching</td>\n",
        "        <td>SH</td>\n",
        "        <td>INTEGER</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "        <td>pitching</td>\n",
        "        <td>ER</td>\n",
        "        <td>INTEGER</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "        <td>pitching</td>\n",
        "        <td>GS</td>\n",
        "        <td>INTEGER</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "        <td>pitching</td>\n",
        "        <td>G</td>\n",
        "        <td>INTEGER</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "        <td>pitching</td>\n",
        "        <td>H</td>\n",
        "        <td>INTEGER</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "        <td>pitching</td>\n",
        "        <td>CG</td>\n",
        "        <td>INTEGER</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "        <td>pitching</td>\n",
        "        <td>L</td>\n",
        "        <td>INTEGER</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "        <td>pitching</td>\n",
        "        <td>GF</td>\n",
        "        <td>INTEGER</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "        <td>pitching</td>\n",
        "        <td>yearID</td>\n",
        "        <td>INTEGER</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "        <td>pitching</td>\n",
        "        <td>BFP</td>\n",
        "        <td>INTEGER</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "        <td>pitching</td>\n",
        "        <td>W</td>\n",
        "        <td>INTEGER</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "        <td>pitching</td>\n",
        "        <td>GIDP</td>\n",
        "        <td>INTEGER</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "        <td>pitching</td>\n",
        "        <td>SHO</td>\n",
        "        <td>INTEGER</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "        <td>pitching</td>\n",
        "        <td>SV</td>\n",
        "        <td>INTEGER</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "        <td>pitching</td>\n",
        "        <td>R</td>\n",
        "        <td>INTEGER</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "        <td>pitching</td>\n",
        "        <td>SO</td>\n",
        "        <td>INTEGER</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "        <td>pitching</td>\n",
        "        <td>SF</td>\n",
        "        <td>INTEGER</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "        <td>pitchingpost</td>\n",
        "        <td>BB</td>\n",
        "        <td>INTEGER</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "        <td>pitchingpost</td>\n",
        "        <td>HR</td>\n",
        "        <td>INTEGER</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "        <td>pitchingpost</td>\n",
        "        <td>IBB</td>\n",
        "        <td>INTEGER</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "        <td>pitchingpost</td>\n",
        "        <td>IPouts</td>\n",
        "        <td>INTEGER</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "        <td>pitchingpost</td>\n",
        "        <td>BK</td>\n",
        "        <td>INTEGER</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "        <td>pitchingpost</td>\n",
        "        <td>WP</td>\n",
        "        <td>INTEGER</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "        <td>pitchingpost</td>\n",
        "        <td>HBP</td>\n",
        "        <td>INTEGER</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "        <td>pitchingpost</td>\n",
        "        <td>SH</td>\n",
        "        <td>INTEGER</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "        <td>pitchingpost</td>\n",
        "        <td>ER</td>\n",
        "        <td>INTEGER</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "        <td>pitchingpost</td>\n",
        "        <td>GS</td>\n",
        "        <td>INTEGER</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "        <td>pitchingpost</td>\n",
        "        <td>G</td>\n",
        "        <td>INTEGER</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "        <td>pitchingpost</td>\n",
        "        <td>H</td>\n",
        "        <td>INTEGER</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "        <td>pitchingpost</td>\n",
        "        <td>CG</td>\n",
        "        <td>INTEGER</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "        <td>pitchingpost</td>\n",
        "        <td>L</td>\n",
        "        <td>INTEGER</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "        <td>pitchingpost</td>\n",
        "        <td>GF</td>\n",
        "        <td>INTEGER</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "        <td>pitchingpost</td>\n",
        "        <td>yearID</td>\n",
        "        <td>INTEGER</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "        <td>pitchingpost</td>\n",
        "        <td>BFP</td>\n",
        "        <td>INTEGER</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "        <td>pitchingpost</td>\n",
        "        <td>W</td>\n",
        "        <td>INTEGER</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "        <td>pitchingpost</td>\n",
        "        <td>GIDP</td>\n",
        "        <td>INTEGER</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "        <td>pitchingpost</td>\n",
        "        <td>SHO</td>\n",
        "        <td>INTEGER</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "        <td>pitchingpost</td>\n",
        "        <td>SV</td>\n",
        "        <td>INTEGER</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "        <td>pitchingpost</td>\n",
        "        <td>SF</td>\n",
        "        <td>INTEGER</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "        <td>pitchingpost</td>\n",
        "        <td>R</td>\n",
        "        <td>INTEGER</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "        <td>pitchingpost</td>\n",
        "        <td>SO</td>\n",
        "        <td>INTEGER</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "        <td>salaries</td>\n",
        "        <td>yearID</td>\n",
        "        <td>INTEGER</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "        <td>schoolsplayers</td>\n",
        "        <td>yearMax</td>\n",
        "        <td>INTEGER</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "        <td>schoolsplayers</td>\n",
        "        <td>yearMin</td>\n",
        "        <td>INTEGER</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "        <td>seriespost</td>\n",
        "        <td>wins</td>\n",
        "        <td>INTEGER</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "        <td>seriespost</td>\n",
        "        <td>yearID</td>\n",
        "        <td>INTEGER</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "        <td>seriespost</td>\n",
        "        <td>losses</td>\n",
        "        <td>INTEGER</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "        <td>seriespost</td>\n",
        "        <td>ties</td>\n",
        "        <td>INTEGER</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "        <td>teams</td>\n",
        "        <td>W</td>\n",
        "        <td>INTEGER</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "        <td>teams</td>\n",
        "        <td>BB</td>\n",
        "        <td>INTEGER</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "        <td>teams</td>\n",
        "        <td>BPF</td>\n",
        "        <td>INTEGER</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "        <td>teams</td>\n",
        "        <td>HR</td>\n",
        "        <td>INTEGER</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "        <td>teams</td>\n",
        "        <td>IPouts</td>\n",
        "        <td>INTEGER</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "        <td>teams</td>\n",
        "        <td>Ghome</td>\n",
        "        <td>INTEGER</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "        <td>teams</td>\n",
        "        <td>3B</td>\n",
        "        <td>INTEGER</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "        <td>teams</td>\n",
        "        <td>HA</td>\n",
        "        <td>INTEGER</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "        <td>teams</td>\n",
        "        <td>HBP</td>\n",
        "        <td>INTEGER</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "        <td>teams</td>\n",
        "        <td>DP</td>\n",
        "        <td>INTEGER</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "        <td>teams</td>\n",
        "        <td>SOA</td>\n",
        "        <td>INTEGER</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "        <td>teams</td>\n",
        "        <td>attendance</td>\n",
        "        <td>INTEGER</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "        <td>teams</td>\n",
        "        <td>PPF</td>\n",
        "        <td>INTEGER</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "        <td>teams</td>\n",
        "        <td>RA</td>\n",
        "        <td>INTEGER</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "        <td>teams</td>\n",
        "        <td>SHO</td>\n",
        "        <td>INTEGER</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "        <td>teams</td>\n",
        "        <td>AB</td>\n",
        "        <td>INTEGER</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "        <td>teams</td>\n",
        "        <td>E</td>\n",
        "        <td>INTEGER</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "        <td>teams</td>\n",
        "        <td>G</td>\n",
        "        <td>INTEGER</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "        <td>teams</td>\n",
        "        <td>H</td>\n",
        "        <td>INTEGER</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "        <td>teams</td>\n",
        "        <td>CG</td>\n",
        "        <td>INTEGER</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "        <td>teams</td>\n",
        "        <td>L</td>\n",
        "        <td>INTEGER</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "        <td>teams</td>\n",
        "        <td>BBA</td>\n",
        "        <td>INTEGER</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "        <td>teams</td>\n",
        "        <td>yearID</td>\n",
        "        <td>INTEGER</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "        <td>teams</td>\n",
        "        <td>R</td>\n",
        "        <td>INTEGER</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "        <td>teams</td>\n",
        "        <td>2B</td>\n",
        "        <td>INTEGER</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "        <td>teams</td>\n",
        "        <td>CS</td>\n",
        "        <td>INTEGER</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "        <td>teams</td>\n",
        "        <td>HRA</td>\n",
        "        <td>INTEGER</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "        <td>teams</td>\n",
        "        <td>ER</td>\n",
        "        <td>INTEGER</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "        <td>teams</td>\n",
        "        <td>SV</td>\n",
        "        <td>INTEGER</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "        <td>teams</td>\n",
        "        <td>Rank</td>\n",
        "        <td>INTEGER</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "        <td>teams</td>\n",
        "        <td>SO</td>\n",
        "        <td>INTEGER</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "        <td>teams</td>\n",
        "        <td>SB</td>\n",
        "        <td>INTEGER</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "        <td>teams</td>\n",
        "        <td>SF</td>\n",
        "        <td>INTEGER</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "        <td>teamshalf</td>\n",
        "        <td>G</td>\n",
        "        <td>INTEGER</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "        <td>teamshalf</td>\n",
        "        <td>Rank</td>\n",
        "        <td>INTEGER</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "        <td>teamshalf</td>\n",
        "        <td>L</td>\n",
        "        <td>INTEGER</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "        <td>teamshalf</td>\n",
        "        <td>yearID</td>\n",
        "        <td>INTEGER</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "        <td>teamshalf</td>\n",
        "        <td>W</td>\n",
        "        <td>INTEGER</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "        <td>tmp_batting</td>\n",
        "        <td>RBI</td>\n",
        "        <td>INTEGER</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "        <td>tmp_batting</td>\n",
        "        <td>BB</td>\n",
        "        <td>INTEGER</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "        <td>tmp_batting</td>\n",
        "        <td>HR</td>\n",
        "        <td>INTEGER</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "        <td>tmp_batting</td>\n",
        "        <td>IBB</td>\n",
        "        <td>INTEGER</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "        <td>tmp_batting</td>\n",
        "        <td>3B</td>\n",
        "        <td>INTEGER</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "        <td>tmp_batting</td>\n",
        "        <td>G_old</td>\n",
        "        <td>INTEGER</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "        <td>tmp_batting</td>\n",
        "        <td>stint</td>\n",
        "        <td>INTEGER</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "        <td>tmp_batting</td>\n",
        "        <td>G_batting</td>\n",
        "        <td>INTEGER</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "        <td>tmp_batting</td>\n",
        "        <td>HBP</td>\n",
        "        <td>INTEGER</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "        <td>tmp_batting</td>\n",
        "        <td>AB</td>\n",
        "        <td>INTEGER</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "        <td>tmp_batting</td>\n",
        "        <td>G</td>\n",
        "        <td>INTEGER</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "        <td>tmp_batting</td>\n",
        "        <td>H</td>\n",
        "        <td>INTEGER</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "        <td>tmp_batting</td>\n",
        "        <td>yearID</td>\n",
        "        <td>INTEGER</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "        <td>tmp_batting</td>\n",
        "        <td>R</td>\n",
        "        <td>INTEGER</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "        <td>tmp_batting</td>\n",
        "        <td>2B</td>\n",
        "        <td>INTEGER</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "        <td>tmp_batting</td>\n",
        "        <td>CS</td>\n",
        "        <td>INTEGER</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "        <td>tmp_batting</td>\n",
        "        <td>GIDP</td>\n",
        "        <td>INTEGER</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "        <td>tmp_batting</td>\n",
        "        <td>SH</td>\n",
        "        <td>INTEGER</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "        <td>tmp_batting</td>\n",
        "        <td>SO</td>\n",
        "        <td>INTEGER</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "        <td>tmp_batting</td>\n",
        "        <td>SB</td>\n",
        "        <td>INTEGER</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "        <td>tmp_batting</td>\n",
        "        <td>SF</td>\n",
        "        <td>INTEGER</td>\n",
        "    </tr>\n",
        "</table>"
       ],
       "metadata": {},
       "output_type": "pyout",
       "prompt_number": 12,
       "text": [
        "+---------------------+-------------+---------+\n",
        "| Table               | Column Name | Type    |\n",
        "+---------------------+-------------+---------+\n",
        "| allstarfull         |      GP     | INTEGER |\n",
        "| allstarfull         |    yearID   | INTEGER |\n",
        "| allstarfull         | startingPos | INTEGER |\n",
        "| allstarfull         |   gameNum   | INTEGER |\n",
        "| appearances         |     G_cf    | INTEGER |\n",
        "| appearances         |    G_all    | INTEGER |\n",
        "| appearances         |     G_2b    | INTEGER |\n",
        "| appearances         |  G_batting  | INTEGER |\n",
        "| appearances         |     G_p     | INTEGER |\n",
        "| appearances         |     G_ss    | INTEGER |\n",
        "| appearances         |     G_of    | INTEGER |\n",
        "| appearances         |     G_c     | INTEGER |\n",
        "| appearances         |     G_dh    | INTEGER |\n",
        "| appearances         |    yearID   | INTEGER |\n",
        "| appearances         |     G_3b    | INTEGER |\n",
        "| appearances         |     G_rf    | INTEGER |\n",
        "| appearances         |     G_1b    | INTEGER |\n",
        "| appearances         |     G_lf    | INTEGER |\n",
        "| appearances         |  G_defense  | INTEGER |\n",
        "| appearances         |     G_ph    | INTEGER |\n",
        "| appearances         |     G_pr    | INTEGER |\n",
        "| awardsmanagers      |    yearID   | INTEGER |\n",
        "| awardsplayers       |    yearID   | INTEGER |\n",
        "| awardssharemanagers |  votesFirst | INTEGER |\n",
        "| awardssharemanagers |  pointsWon  | INTEGER |\n",
        "| awardssharemanagers |    yearID   | INTEGER |\n",
        "| awardssharemanagers |  pointsMax  | INTEGER |\n",
        "| awardsshareplayers  |    yearID   | INTEGER |\n",
        "| awardsshareplayers  |  pointsMax  | INTEGER |\n",
        "| battingpost         |     RBI     | INTEGER |\n",
        "| battingpost         |      BB     | INTEGER |\n",
        "| battingpost         |      HR     | INTEGER |\n",
        "| battingpost         |     IBB     | INTEGER |\n",
        "| battingpost         |      3B     | INTEGER |\n",
        "| battingpost         |     HBP     | INTEGER |\n",
        "| battingpost         |      AB     | INTEGER |\n",
        "| battingpost         |      G      | INTEGER |\n",
        "| battingpost         |      H      | INTEGER |\n",
        "| battingpost         |    yearID   | INTEGER |\n",
        "| battingpost         |      R      | INTEGER |\n",
        "| battingpost         |      2B     | INTEGER |\n",
        "| battingpost         |      CS     | INTEGER |\n",
        "| battingpost         |     GIDP    | INTEGER |\n",
        "| battingpost         |      SF     | INTEGER |\n",
        "| battingpost         |      SH     | INTEGER |\n",
        "| battingpost         |      SO     | INTEGER |\n",
        "| battingpost         |      SB     | INTEGER |\n",
        "| fielding            |      WP     | INTEGER |\n",
        "| fielding            |      E      | INTEGER |\n",
        "| fielding            |    stint    | INTEGER |\n",
        "| fielding            |      DP     | INTEGER |\n",
        "| fielding            |      PB     | INTEGER |\n",
        "| fielding            |      PO     | INTEGER |\n",
        "| fielding            |      A      | INTEGER |\n",
        "| fielding            |      GS     | INTEGER |\n",
        "| fielding            |      G      | INTEGER |\n",
        "| fielding            |    yearID   | INTEGER |\n",
        "| fielding            |      CS     | INTEGER |\n",
        "| fielding            |   InnOuts   | INTEGER |\n",
        "| fielding            |      SB     | INTEGER |\n",
        "| fieldingof          |     Gcf     | INTEGER |\n",
        "| fieldingof          |     Glf     | INTEGER |\n",
        "| fieldingof          |     Grf     | INTEGER |\n",
        "| fieldingof          |    yearID   | INTEGER |\n",
        "| fieldingof          |    stint    | INTEGER |\n",
        "| fieldingpost        |      A      | INTEGER |\n",
        "| fieldingpost        |      G      | INTEGER |\n",
        "| fieldingpost        |      TP     | INTEGER |\n",
        "| fieldingpost        |      PB     | INTEGER |\n",
        "| fieldingpost        |   InnOuts   | INTEGER |\n",
        "| fieldingpost        |    yearID   | INTEGER |\n",
        "| fieldingpost        |      PO     | INTEGER |\n",
        "| fieldingpost        |      SB     | INTEGER |\n",
        "| fieldingpost        |      CS     | INTEGER |\n",
        "| fieldingpost        |      GS     | INTEGER |\n",
        "| fieldingpost        |      E      | INTEGER |\n",
        "| fieldingpost        |      DP     | INTEGER |\n",
        "| halloffame          |    votes    | INTEGER |\n",
        "| halloffame          |    needed   | INTEGER |\n",
        "| halloffame          |    yearid   | INTEGER |\n",
        "| halloffame          |   ballots   | INTEGER |\n",
        "| hofold              |    votes    | INTEGER |\n",
        "| hofold              |    yearid   | INTEGER |\n",
        "| hofold              |   ballots   | INTEGER |\n",
        "| managers            |      G      | INTEGER |\n",
        "| managers            |     rank    | INTEGER |\n",
        "| managers            |      W      | INTEGER |\n",
        "| managers            |    yearID   | INTEGER |\n",
        "| managers            |   inseason  | INTEGER |\n",
        "| managers            |      L      | INTEGER |\n",
        "| managershalf        |      G      | INTEGER |\n",
        "| managershalf        |     rank    | INTEGER |\n",
        "| managershalf        |      W      | INTEGER |\n",
        "| managershalf        |    yearID   | INTEGER |\n",
        "| managershalf        |   inseason  | INTEGER |\n",
        "| managershalf        |     half    | INTEGER |\n",
        "| managershalf        |      L      | INTEGER |\n",
        "| master              |    weight   | INTEGER |\n",
        "| master              |   lahmanID  | INTEGER |\n",
        "| master              |  birthMonth | INTEGER |\n",
        "| master              |  deathMonth | INTEGER |\n",
        "| master              |  deathYear  | INTEGER |\n",
        "| master              |  birthYear  | INTEGER |\n",
        "| master              |   birthDay  | INTEGER |\n",
        "| master              |   deathDay  | INTEGER |\n",
        "| pitching            |      BB     | INTEGER |\n",
        "| pitching            |      HR     | INTEGER |\n",
        "| pitching            |     IBB     | INTEGER |\n",
        "| pitching            |    IPouts   | INTEGER |\n",
        "| pitching            |      BK     | INTEGER |\n",
        "| pitching            |      WP     | INTEGER |\n",
        "| pitching            |    stint    | INTEGER |\n",
        "| pitching            |     HBP     | INTEGER |\n",
        "| pitching            |      SH     | INTEGER |\n",
        "| pitching            |      ER     | INTEGER |\n",
        "| pitching            |      GS     | INTEGER |\n",
        "| pitching            |      G      | INTEGER |\n",
        "| pitching            |      H      | INTEGER |\n",
        "| pitching            |      CG     | INTEGER |\n",
        "| pitching            |      L      | INTEGER |\n",
        "| pitching            |      GF     | INTEGER |\n",
        "| pitching            |    yearID   | INTEGER |\n",
        "| pitching            |     BFP     | INTEGER |\n",
        "| pitching            |      W      | INTEGER |\n",
        "| pitching            |     GIDP    | INTEGER |\n",
        "| pitching            |     SHO     | INTEGER |\n",
        "| pitching            |      SV     | INTEGER |\n",
        "| pitching            |      R      | INTEGER |\n",
        "| pitching            |      SO     | INTEGER |\n",
        "| pitching            |      SF     | INTEGER |\n",
        "| pitchingpost        |      BB     | INTEGER |\n",
        "| pitchingpost        |      HR     | INTEGER |\n",
        "| pitchingpost        |     IBB     | INTEGER |\n",
        "| pitchingpost        |    IPouts   | INTEGER |\n",
        "| pitchingpost        |      BK     | INTEGER |\n",
        "| pitchingpost        |      WP     | INTEGER |\n",
        "| pitchingpost        |     HBP     | INTEGER |\n",
        "| pitchingpost        |      SH     | INTEGER |\n",
        "| pitchingpost        |      ER     | INTEGER |\n",
        "| pitchingpost        |      GS     | INTEGER |\n",
        "| pitchingpost        |      G      | INTEGER |\n",
        "| pitchingpost        |      H      | INTEGER |\n",
        "| pitchingpost        |      CG     | INTEGER |\n",
        "| pitchingpost        |      L      | INTEGER |\n",
        "| pitchingpost        |      GF     | INTEGER |\n",
        "| pitchingpost        |    yearID   | INTEGER |\n",
        "| pitchingpost        |     BFP     | INTEGER |\n",
        "| pitchingpost        |      W      | INTEGER |\n",
        "| pitchingpost        |     GIDP    | INTEGER |\n",
        "| pitchingpost        |     SHO     | INTEGER |\n",
        "| pitchingpost        |      SV     | INTEGER |\n",
        "| pitchingpost        |      SF     | INTEGER |\n",
        "| pitchingpost        |      R      | INTEGER |\n",
        "| pitchingpost        |      SO     | INTEGER |\n",
        "| salaries            |    yearID   | INTEGER |\n",
        "| schoolsplayers      |   yearMax   | INTEGER |\n",
        "| schoolsplayers      |   yearMin   | INTEGER |\n",
        "| seriespost          |     wins    | INTEGER |\n",
        "| seriespost          |    yearID   | INTEGER |\n",
        "| seriespost          |    losses   | INTEGER |\n",
        "| seriespost          |     ties    | INTEGER |\n",
        "| teams               |      W      | INTEGER |\n",
        "| teams               |      BB     | INTEGER |\n",
        "| teams               |     BPF     | INTEGER |\n",
        "| teams               |      HR     | INTEGER |\n",
        "| teams               |    IPouts   | INTEGER |\n",
        "| teams               |    Ghome    | INTEGER |\n",
        "| teams               |      3B     | INTEGER |\n",
        "| teams               |      HA     | INTEGER |\n",
        "| teams               |     HBP     | INTEGER |\n",
        "| teams               |      DP     | INTEGER |\n",
        "| teams               |     SOA     | INTEGER |\n",
        "| teams               |  attendance | INTEGER |\n",
        "| teams               |     PPF     | INTEGER |\n",
        "| teams               |      RA     | INTEGER |\n",
        "| teams               |     SHO     | INTEGER |\n",
        "| teams               |      AB     | INTEGER |\n",
        "| teams               |      E      | INTEGER |\n",
        "| teams               |      G      | INTEGER |\n",
        "| teams               |      H      | INTEGER |\n",
        "| teams               |      CG     | INTEGER |\n",
        "| teams               |      L      | INTEGER |\n",
        "| teams               |     BBA     | INTEGER |\n",
        "| teams               |    yearID   | INTEGER |\n",
        "| teams               |      R      | INTEGER |\n",
        "| teams               |      2B     | INTEGER |\n",
        "| teams               |      CS     | INTEGER |\n",
        "| teams               |     HRA     | INTEGER |\n",
        "| teams               |      ER     | INTEGER |\n",
        "| teams               |      SV     | INTEGER |\n",
        "| teams               |     Rank    | INTEGER |\n",
        "| teams               |      SO     | INTEGER |\n",
        "| teams               |      SB     | INTEGER |\n",
        "| teams               |      SF     | INTEGER |\n",
        "| teamshalf           |      G      | INTEGER |\n",
        "| teamshalf           |     Rank    | INTEGER |\n",
        "| teamshalf           |      L      | INTEGER |\n",
        "| teamshalf           |    yearID   | INTEGER |\n",
        "| teamshalf           |      W      | INTEGER |\n",
        "| tmp_batting         |     RBI     | INTEGER |\n",
        "| tmp_batting         |      BB     | INTEGER |\n",
        "| tmp_batting         |      HR     | INTEGER |\n",
        "| tmp_batting         |     IBB     | INTEGER |\n",
        "| tmp_batting         |      3B     | INTEGER |\n",
        "| tmp_batting         |    G_old    | INTEGER |\n",
        "| tmp_batting         |    stint    | INTEGER |\n",
        "| tmp_batting         |  G_batting  | INTEGER |\n",
        "| tmp_batting         |     HBP     | INTEGER |\n",
        "| tmp_batting         |      AB     | INTEGER |\n",
        "| tmp_batting         |      G      | INTEGER |\n",
        "| tmp_batting         |      H      | INTEGER |\n",
        "| tmp_batting         |    yearID   | INTEGER |\n",
        "| tmp_batting         |      R      | INTEGER |\n",
        "| tmp_batting         |      2B     | INTEGER |\n",
        "| tmp_batting         |      CS     | INTEGER |\n",
        "| tmp_batting         |     GIDP    | INTEGER |\n",
        "| tmp_batting         |      SH     | INTEGER |\n",
        "| tmp_batting         |      SO     | INTEGER |\n",
        "| tmp_batting         |      SB     | INTEGER |\n",
        "| tmp_batting         |      SF     | INTEGER |\n",
        "+---------------------+-------------+---------+"
       ]
      }
     ],
     "prompt_number": 12
    },
    {
     "cell_type": "code",
     "collapsed": false,
     "input": [
      "db.find_table(\"*\")"
     ],
     "language": "python",
     "metadata": {},
     "outputs": [
      {
       "html": [
        "<table>\n",
        "    <tr>\n",
        "        <th>Table</th>\n",
        "        <th>Columns</th>\n",
        "    </tr>\n",
        "    <tr>\n",
        "        <td>allstarfull</td>\n",
        "        <td>playerID, yearID, gameNum, gameID, teamID, lgID, GP, startingPos</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "        <td>appearances</td>\n",
        "        <td>yearID, teamID, lgID, playerID, G_all, G_batting, G_defense, G_p, G_c, G_1b, G_2<br>b, G_3b, G_ss, G_lf, G_cf, G_rf, G_of, G_dh, G_ph, G_pr</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "        <td>awardsmanagers</td>\n",
        "        <td>managerID, awardID, yearID, lgID, tie, notes</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "        <td>awardsplayers</td>\n",
        "        <td>playerID, awardID, yearID, lgID, tie, notes</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "        <td>awardssharemanagers</td>\n",
        "        <td>awardID, yearID, lgID, managerID, pointsWon, pointsMax, votesFirst</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "        <td>awardsshareplayers</td>\n",
        "        <td>awardID, yearID, lgID, playerID, pointsWon, pointsMax, votesFirst</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "        <td>battingpost</td>\n",
        "        <td>yearID, round, playerID, teamID, lgID, G, AB, R, H, 2B, 3B, HR, RBI, SB, CS, BB,<br> SO, IBB, HBP, SH, SF, GIDP</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "        <td>fielding</td>\n",
        "        <td>playerID, yearID, stint, teamID, lgID, POS, G, GS, InnOuts, PO, A, E, DP, PB, WP<br>, SB, CS, ZR</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "        <td>fieldingof</td>\n",
        "        <td>playerID, yearID, stint, Glf, Gcf, Grf</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "        <td>fieldingpost</td>\n",
        "        <td>playerID, yearID, teamID, lgID, round, POS, G, GS, InnOuts, PO, A, E, DP, TP, PB<br>, SB, CS</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "        <td>halloffame</td>\n",
        "        <td>hofID, yearid, votedBy, ballots, needed, votes, inducted, category</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "        <td>hofold</td>\n",
        "        <td>hofID, yearid, votedBy, ballots, votes, inducted, category</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "        <td>managers</td>\n",
        "        <td>managerID, yearID, teamID, lgID, inseason, G, W, L, rank, plyrMgr</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "        <td>managershalf</td>\n",
        "        <td>managerID, yearID, teamID, lgID, inseason, half, G, W, L, rank</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "        <td>master</td>\n",
        "        <td>lahmanID, playerID, managerID, hofID, birthYear, birthMonth, birthDay, birthCoun<br>try, birthState, birthCity, deathYear, deathMonth, deathDay, deathCountry, death<br>State, deathCity, nameFirst, nameLast, nameNote, nameGiven, nameNick, weight, he<br>ight, bats, throws, debut, finalGame, college, lahman40ID, lahman45ID, retroID, <br>holtzID, bbrefID</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "        <td>pitching</td>\n",
        "        <td>playerID, yearID, stint, teamID, lgID, W, L, G, GS, CG, SHO, SV, IPouts, H, ER, <br>HR, BB, SO, BAOpp, ERA, IBB, WP, HBP, BK, BFP, GF, R, SH, SF, GIDP</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "        <td>pitchingpost</td>\n",
        "        <td>playerID, yearID, round, teamID, lgID, W, L, G, GS, CG, SHO, SV, IPouts, H, ER, <br>HR, BB, SO, BAOpp, ERA, IBB, WP, HBP, BK, BFP, GF, R, SH, SF, GIDP</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "        <td>salaries</td>\n",
        "        <td>yearID, teamID, lgID, playerID, salary</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "        <td>schools</td>\n",
        "        <td>schoolID, schoolName, schoolCity, schoolState, schoolNick</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "        <td>schoolsplayers</td>\n",
        "        <td>playerID, schoolID, yearMin, yearMax</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "        <td>seriespost</td>\n",
        "        <td>yearID, round, teamIDwinner, lgIDwinner, teamIDloser, lgIDloser, wins, losses, t<br>ies</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "        <td>teams</td>\n",
        "        <td>yearID, lgID, teamID, franchID, divID, Rank, G, Ghome, W, L, DivWin, WCWin, LgWi<br>n, WSWin, R, AB, H, 2B, 3B, HR, BB, SO, SB, CS, HBP, SF, RA, ER, ERA, CG, SHO, S<br>V, IPouts, HA, HRA, BBA, SOA, E, DP, FP, name, park, attendance, BPF, PPF, teamI<br>DBR, teamIDlahman45, teamIDretro</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "        <td>teamsfranchises</td>\n",
        "        <td>franchID, franchName, active, NAassoc</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "        <td>teamshalf</td>\n",
        "        <td>yearID, lgID, teamID, Half, divID, DivWin, Rank, G, W, L</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "        <td>tmp_batting</td>\n",
        "        <td>playerID, yearID, stint, teamID, lgID, G, G_batting, AB, R, H, 2B, 3B, HR, RBI, <br>SB, CS, BB, SO, IBB, HBP, SH, SF, GIDP, G_old</td>\n",
        "    </tr>\n",
        "</table>"
       ],
       "metadata": {},
       "output_type": "pyout",
       "prompt_number": 13,
       "text": [
        "+---------------------+----------------------------------------------------------------------------------+\n",
        "| Table               | Columns                                                                          |\n",
        "+---------------------+----------------------------------------------------------------------------------+\n",
        "| allstarfull         | playerID, yearID, gameNum, gameID, teamID, lgID, GP, startingPos                 |\n",
        "| appearances         | yearID, teamID, lgID, playerID, G_all, G_batting, G_defense, G_p, G_c, G_1b, G_2 |\n",
        "|                     | b, G_3b, G_ss, G_lf, G_cf, G_rf, G_of, G_dh, G_ph, G_pr                          |\n",
        "| awardsmanagers      | managerID, awardID, yearID, lgID, tie, notes                                     |\n",
        "| awardsplayers       | playerID, awardID, yearID, lgID, tie, notes                                      |\n",
        "| awardssharemanagers | awardID, yearID, lgID, managerID, pointsWon, pointsMax, votesFirst               |\n",
        "| awardsshareplayers  | awardID, yearID, lgID, playerID, pointsWon, pointsMax, votesFirst                |\n",
        "| battingpost         | yearID, round, playerID, teamID, lgID, G, AB, R, H, 2B, 3B, HR, RBI, SB, CS, BB, |\n",
        "|                     |  SO, IBB, HBP, SH, SF, GIDP                                                      |\n",
        "| fielding            | playerID, yearID, stint, teamID, lgID, POS, G, GS, InnOuts, PO, A, E, DP, PB, WP |\n",
        "|                     | , SB, CS, ZR                                                                     |\n",
        "| fieldingof          | playerID, yearID, stint, Glf, Gcf, Grf                                           |\n",
        "| fieldingpost        | playerID, yearID, teamID, lgID, round, POS, G, GS, InnOuts, PO, A, E, DP, TP, PB |\n",
        "|                     | , SB, CS                                                                         |\n",
        "| halloffame          | hofID, yearid, votedBy, ballots, needed, votes, inducted, category               |\n",
        "| hofold              | hofID, yearid, votedBy, ballots, votes, inducted, category                       |\n",
        "| managers            | managerID, yearID, teamID, lgID, inseason, G, W, L, rank, plyrMgr                |\n",
        "| managershalf        | managerID, yearID, teamID, lgID, inseason, half, G, W, L, rank                   |\n",
        "| master              | lahmanID, playerID, managerID, hofID, birthYear, birthMonth, birthDay, birthCoun |\n",
        "|                     | try, birthState, birthCity, deathYear, deathMonth, deathDay, deathCountry, death |\n",
        "|                     | State, deathCity, nameFirst, nameLast, nameNote, nameGiven, nameNick, weight, he |\n",
        "|                     | ight, bats, throws, debut, finalGame, college, lahman40ID, lahman45ID, retroID,  |\n",
        "|                     | holtzID, bbrefID                                                                 |\n",
        "| pitching            | playerID, yearID, stint, teamID, lgID, W, L, G, GS, CG, SHO, SV, IPouts, H, ER,  |\n",
        "|                     | HR, BB, SO, BAOpp, ERA, IBB, WP, HBP, BK, BFP, GF, R, SH, SF, GIDP               |\n",
        "| pitchingpost        | playerID, yearID, round, teamID, lgID, W, L, G, GS, CG, SHO, SV, IPouts, H, ER,  |\n",
        "|                     | HR, BB, SO, BAOpp, ERA, IBB, WP, HBP, BK, BFP, GF, R, SH, SF, GIDP               |\n",
        "| salaries            | yearID, teamID, lgID, playerID, salary                                           |\n",
        "| schools             | schoolID, schoolName, schoolCity, schoolState, schoolNick                        |\n",
        "| schoolsplayers      | playerID, schoolID, yearMin, yearMax                                             |\n",
        "| seriespost          | yearID, round, teamIDwinner, lgIDwinner, teamIDloser, lgIDloser, wins, losses, t |\n",
        "|                     | ies                                                                              |\n",
        "| teams               | yearID, lgID, teamID, franchID, divID, Rank, G, Ghome, W, L, DivWin, WCWin, LgWi |\n",
        "|                     | n, WSWin, R, AB, H, 2B, 3B, HR, BB, SO, SB, CS, HBP, SF, RA, ER, ERA, CG, SHO, S |\n",
        "|                     | V, IPouts, HA, HRA, BBA, SOA, E, DP, FP, name, park, attendance, BPF, PPF, teamI |\n",
        "|                     | DBR, teamIDlahman45, teamIDretro                                                 |\n",
        "| teamsfranchises     | franchID, franchName, active, NAassoc                                            |\n",
        "| teamshalf           | yearID, lgID, teamID, Half, divID, DivWin, Rank, G, W, L                         |\n",
        "| tmp_batting         | playerID, yearID, stint, teamID, lgID, G, G_batting, AB, R, H, 2B, 3B, HR, RBI,  |\n",
        "|                     | SB, CS, BB, SO, IBB, HBP, SH, SF, GIDP, G_old                                    |\n",
        "+---------------------+----------------------------------------------------------------------------------+"
       ]
      }
     ],
     "prompt_number": 13
    },
    {
     "cell_type": "code",
     "collapsed": false,
     "input": [
      "db.find_table(\"*batting*\")"
     ],
     "language": "python",
     "metadata": {},
     "outputs": [
      {
       "html": [
        "<table>\n",
        "    <tr>\n",
        "        <th>Table</th>\n",
        "        <th>Columns</th>\n",
        "    </tr>\n",
        "    <tr>\n",
        "        <td>battingpost</td>\n",
        "        <td>yearID, round, playerID, teamID, lgID, G, AB, R, H, 2B, 3B, HR, RBI, SB, CS, BB,<br> SO, IBB, HBP, SH, SF, GIDP</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "        <td>tmp_batting</td>\n",
        "        <td>playerID, yearID, stint, teamID, lgID, G, G_batting, AB, R, H, 2B, 3B, HR, RBI, <br>SB, CS, BB, SO, IBB, HBP, SH, SF, GIDP, G_old</td>\n",
        "    </tr>\n",
        "</table>"
       ],
       "metadata": {},
       "output_type": "pyout",
       "prompt_number": 14,
       "text": [
        "+-------------+----------------------------------------------------------------------------------+\n",
        "| Table       | Columns                                                                          |\n",
        "+-------------+----------------------------------------------------------------------------------+\n",
        "| battingpost | yearID, round, playerID, teamID, lgID, G, AB, R, H, 2B, 3B, HR, RBI, SB, CS, BB, |\n",
        "|             |  SO, IBB, HBP, SH, SF, GIDP                                                      |\n",
        "| tmp_batting | playerID, yearID, stint, teamID, lgID, G, G_batting, AB, R, H, 2B, 3B, HR, RBI,  |\n",
        "|             | SB, CS, BB, SO, IBB, HBP, SH, SF, GIDP, G_old                                    |\n",
        "+-------------+----------------------------------------------------------------------------------+"
       ]
      }
     ],
     "prompt_number": 14
    },
    {
     "cell_type": "code",
     "collapsed": false,
     "input": [
      "db.save_credentials(\"baseball\")"
     ],
     "language": "python",
     "metadata": {},
     "outputs": [],
     "prompt_number": 15
    },
    {
     "cell_type": "code",
     "collapsed": false,
     "input": [
      "from db import DB"
     ],
     "language": "python",
     "metadata": {},
     "outputs": [],
     "prompt_number": 16
    },
    {
     "cell_type": "code",
     "collapsed": false,
     "input": [
      "db = DB(profile=\"baseball\", dbtype=\"sqlite\")"
     ],
     "language": "python",
     "metadata": {},
     "outputs": [
      {
       "output_type": "stream",
       "stream": "stderr",
       "text": [
        "Indexing schema. This will take a second...finished!\n"
       ]
      }
     ],
     "prompt_number": 17
    },
    {
     "cell_type": "code",
     "collapsed": false,
     "input": [
      "db.tables"
     ],
     "language": "python",
     "metadata": {},
     "outputs": [
      {
       "html": [
        "<table>\n",
        "    <tr>\n",
        "        <th>Table</th>\n",
        "        <th>Columns</th>\n",
        "    </tr>\n",
        "    <tr>\n",
        "        <td>allstarfull</td>\n",
        "        <td>playerID, yearID, gameNum, gameID, teamID, lgID, GP, startingPos</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "        <td>appearances</td>\n",
        "        <td>yearID, teamID, lgID, playerID, G_all, G_batting, G_defense, G_p, G_c, G_1b, G_2<br>b, G_3b, G_ss, G_lf, G_cf, G_rf, G_of, G_dh, G_ph, G_pr</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "        <td>awardsmanagers</td>\n",
        "        <td>managerID, awardID, yearID, lgID, tie, notes</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "        <td>awardsplayers</td>\n",
        "        <td>playerID, awardID, yearID, lgID, tie, notes</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "        <td>awardssharemanagers</td>\n",
        "        <td>awardID, yearID, lgID, managerID, pointsWon, pointsMax, votesFirst</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "        <td>awardsshareplayers</td>\n",
        "        <td>awardID, yearID, lgID, playerID, pointsWon, pointsMax, votesFirst</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "        <td>battingpost</td>\n",
        "        <td>yearID, round, playerID, teamID, lgID, G, AB, R, H, 2B, 3B, HR, RBI, SB, CS, BB,<br> SO, IBB, HBP, SH, SF, GIDP</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "        <td>fielding</td>\n",
        "        <td>playerID, yearID, stint, teamID, lgID, POS, G, GS, InnOuts, PO, A, E, DP, PB, WP<br>, SB, CS, ZR</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "        <td>fieldingof</td>\n",
        "        <td>playerID, yearID, stint, Glf, Gcf, Grf</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "        <td>fieldingpost</td>\n",
        "        <td>playerID, yearID, teamID, lgID, round, POS, G, GS, InnOuts, PO, A, E, DP, TP, PB<br>, SB, CS</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "        <td>halloffame</td>\n",
        "        <td>hofID, yearid, votedBy, ballots, needed, votes, inducted, category</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "        <td>hofold</td>\n",
        "        <td>hofID, yearid, votedBy, ballots, votes, inducted, category</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "        <td>managers</td>\n",
        "        <td>managerID, yearID, teamID, lgID, inseason, G, W, L, rank, plyrMgr</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "        <td>managershalf</td>\n",
        "        <td>managerID, yearID, teamID, lgID, inseason, half, G, W, L, rank</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "        <td>master</td>\n",
        "        <td>lahmanID, playerID, managerID, hofID, birthYear, birthMonth, birthDay, birthCoun<br>try, birthState, birthCity, deathYear, deathMonth, deathDay, deathCountry, death<br>State, deathCity, nameFirst, nameLast, nameNote, nameGiven, nameNick, weight, he<br>ight, bats, throws, debut, finalGame, college, lahman40ID, lahman45ID, retroID, <br>holtzID, bbrefID</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "        <td>pitching</td>\n",
        "        <td>playerID, yearID, stint, teamID, lgID, W, L, G, GS, CG, SHO, SV, IPouts, H, ER, <br>HR, BB, SO, BAOpp, ERA, IBB, WP, HBP, BK, BFP, GF, R, SH, SF, GIDP</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "        <td>pitchingpost</td>\n",
        "        <td>playerID, yearID, round, teamID, lgID, W, L, G, GS, CG, SHO, SV, IPouts, H, ER, <br>HR, BB, SO, BAOpp, ERA, IBB, WP, HBP, BK, BFP, GF, R, SH, SF, GIDP</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "        <td>salaries</td>\n",
        "        <td>yearID, teamID, lgID, playerID, salary</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "        <td>schools</td>\n",
        "        <td>schoolID, schoolName, schoolCity, schoolState, schoolNick</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "        <td>schoolsplayers</td>\n",
        "        <td>playerID, schoolID, yearMin, yearMax</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "        <td>seriespost</td>\n",
        "        <td>yearID, round, teamIDwinner, lgIDwinner, teamIDloser, lgIDloser, wins, losses, t<br>ies</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "        <td>teams</td>\n",
        "        <td>yearID, lgID, teamID, franchID, divID, Rank, G, Ghome, W, L, DivWin, WCWin, LgWi<br>n, WSWin, R, AB, H, 2B, 3B, HR, BB, SO, SB, CS, HBP, SF, RA, ER, ERA, CG, SHO, S<br>V, IPouts, HA, HRA, BBA, SOA, E, DP, FP, name, park, attendance, BPF, PPF, teamI<br>DBR, teamIDlahman45, teamIDretro</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "        <td>teamsfranchises</td>\n",
        "        <td>franchID, franchName, active, NAassoc</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "        <td>teamshalf</td>\n",
        "        <td>yearID, lgID, teamID, Half, divID, DivWin, Rank, G, W, L</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "        <td>tmp_batting</td>\n",
        "        <td>playerID, yearID, stint, teamID, lgID, G, G_batting, AB, R, H, 2B, 3B, HR, RBI, <br>SB, CS, BB, SO, IBB, HBP, SH, SF, GIDP, G_old</td>\n",
        "    </tr>\n",
        "</table>"
       ],
       "metadata": {},
       "output_type": "pyout",
       "prompt_number": 18,
       "text": [
        "+---------------------+----------------------------------------------------------------------------------+\n",
        "| Table               | Columns                                                                          |\n",
        "+---------------------+----------------------------------------------------------------------------------+\n",
        "| allstarfull         | playerID, yearID, gameNum, gameID, teamID, lgID, GP, startingPos                 |\n",
        "| appearances         | yearID, teamID, lgID, playerID, G_all, G_batting, G_defense, G_p, G_c, G_1b, G_2 |\n",
        "|                     | b, G_3b, G_ss, G_lf, G_cf, G_rf, G_of, G_dh, G_ph, G_pr                          |\n",
        "| awardsmanagers      | managerID, awardID, yearID, lgID, tie, notes                                     |\n",
        "| awardsplayers       | playerID, awardID, yearID, lgID, tie, notes                                      |\n",
        "| awardssharemanagers | awardID, yearID, lgID, managerID, pointsWon, pointsMax, votesFirst               |\n",
        "| awardsshareplayers  | awardID, yearID, lgID, playerID, pointsWon, pointsMax, votesFirst                |\n",
        "| battingpost         | yearID, round, playerID, teamID, lgID, G, AB, R, H, 2B, 3B, HR, RBI, SB, CS, BB, |\n",
        "|                     |  SO, IBB, HBP, SH, SF, GIDP                                                      |\n",
        "| fielding            | playerID, yearID, stint, teamID, lgID, POS, G, GS, InnOuts, PO, A, E, DP, PB, WP |\n",
        "|                     | , SB, CS, ZR                                                                     |\n",
        "| fieldingof          | playerID, yearID, stint, Glf, Gcf, Grf                                           |\n",
        "| fieldingpost        | playerID, yearID, teamID, lgID, round, POS, G, GS, InnOuts, PO, A, E, DP, TP, PB |\n",
        "|                     | , SB, CS                                                                         |\n",
        "| halloffame          | hofID, yearid, votedBy, ballots, needed, votes, inducted, category               |\n",
        "| hofold              | hofID, yearid, votedBy, ballots, votes, inducted, category                       |\n",
        "| managers            | managerID, yearID, teamID, lgID, inseason, G, W, L, rank, plyrMgr                |\n",
        "| managershalf        | managerID, yearID, teamID, lgID, inseason, half, G, W, L, rank                   |\n",
        "| master              | lahmanID, playerID, managerID, hofID, birthYear, birthMonth, birthDay, birthCoun |\n",
        "|                     | try, birthState, birthCity, deathYear, deathMonth, deathDay, deathCountry, death |\n",
        "|                     | State, deathCity, nameFirst, nameLast, nameNote, nameGiven, nameNick, weight, he |\n",
        "|                     | ight, bats, throws, debut, finalGame, college, lahman40ID, lahman45ID, retroID,  |\n",
        "|                     | holtzID, bbrefID                                                                 |\n",
        "| pitching            | playerID, yearID, stint, teamID, lgID, W, L, G, GS, CG, SHO, SV, IPouts, H, ER,  |\n",
        "|                     | HR, BB, SO, BAOpp, ERA, IBB, WP, HBP, BK, BFP, GF, R, SH, SF, GIDP               |\n",
        "| pitchingpost        | playerID, yearID, round, teamID, lgID, W, L, G, GS, CG, SHO, SV, IPouts, H, ER,  |\n",
        "|                     | HR, BB, SO, BAOpp, ERA, IBB, WP, HBP, BK, BFP, GF, R, SH, SF, GIDP               |\n",
        "| salaries            | yearID, teamID, lgID, playerID, salary                                           |\n",
        "| schools             | schoolID, schoolName, schoolCity, schoolState, schoolNick                        |\n",
        "| schoolsplayers      | playerID, schoolID, yearMin, yearMax                                             |\n",
        "| seriespost          | yearID, round, teamIDwinner, lgIDwinner, teamIDloser, lgIDloser, wins, losses, t |\n",
        "|                     | ies                                                                              |\n",
        "| teams               | yearID, lgID, teamID, franchID, divID, Rank, G, Ghome, W, L, DivWin, WCWin, LgWi |\n",
        "|                     | n, WSWin, R, AB, H, 2B, 3B, HR, BB, SO, SB, CS, HBP, SF, RA, ER, ERA, CG, SHO, S |\n",
        "|                     | V, IPouts, HA, HRA, BBA, SOA, E, DP, FP, name, park, attendance, BPF, PPF, teamI |\n",
        "|                     | DBR, teamIDlahman45, teamIDretro                                                 |\n",
        "| teamsfranchises     | franchID, franchName, active, NAassoc                                            |\n",
        "| teamshalf           | yearID, lgID, teamID, Half, divID, DivWin, Rank, G, W, L                         |\n",
        "| tmp_batting         | playerID, yearID, stint, teamID, lgID, G, G_batting, AB, R, H, 2B, 3B, HR, RBI,  |\n",
        "|                     | SB, CS, BB, SO, IBB, HBP, SH, SF, GIDP, G_old                                    |\n",
        "+---------------------+----------------------------------------------------------------------------------+"
       ]
      }
     ],
     "prompt_number": 18
    },
    {
     "cell_type": "code",
     "collapsed": false,
     "input": [
      "db.tables.appearances.head()"
     ],
     "language": "python",
     "metadata": {},
     "outputs": [
      {
       "html": [
        "<div style=\"max-height:1000px;max-width:1500px;overflow:auto;\">\n",
        "<table border=\"1\" class=\"dataframe\">\n",
        "  <thead>\n",
        "    <tr style=\"text-align: right;\">\n",
        "      <th></th>\n",
        "      <th>yearID</th>\n",
        "      <th>teamID</th>\n",
        "      <th>lgID</th>\n",
        "      <th>playerID</th>\n",
        "      <th>G_all</th>\n",
        "      <th>G_batting</th>\n",
        "      <th>G_defense</th>\n",
        "      <th>G_p</th>\n",
        "      <th>G_c</th>\n",
        "      <th>G_1b</th>\n",
        "      <th>G_2b</th>\n",
        "      <th>G_3b</th>\n",
        "      <th>G_ss</th>\n",
        "      <th>G_lf</th>\n",
        "      <th>G_cf</th>\n",
        "      <th>G_rf</th>\n",
        "      <th>G_of</th>\n",
        "      <th>G_dh</th>\n",
        "      <th>G_ph</th>\n",
        "      <th>G_pr</th>\n",
        "    </tr>\n",
        "  </thead>\n",
        "  <tbody>\n",
        "    <tr>\n",
        "      <th>0</th>\n",
        "      <td> 1871</td>\n",
        "      <td> BS1</td>\n",
        "      <td> NA</td>\n",
        "      <td> barnero01</td>\n",
        "      <td> 31</td>\n",
        "      <td> None</td>\n",
        "      <td> 31</td>\n",
        "      <td> 31</td>\n",
        "      <td> 0</td>\n",
        "      <td> 0</td>\n",
        "      <td>  0</td>\n",
        "      <td> 16</td>\n",
        "      <td> 0</td>\n",
        "      <td> 15</td>\n",
        "      <td>  0</td>\n",
        "      <td> 0</td>\n",
        "      <td>  0</td>\n",
        "      <td>  0</td>\n",
        "      <td> None</td>\n",
        "      <td> None</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "      <th>1</th>\n",
        "      <td> 1871</td>\n",
        "      <td> BS1</td>\n",
        "      <td> NA</td>\n",
        "      <td> barrofr01</td>\n",
        "      <td> 18</td>\n",
        "      <td> None</td>\n",
        "      <td> 18</td>\n",
        "      <td> 18</td>\n",
        "      <td> 0</td>\n",
        "      <td> 0</td>\n",
        "      <td>  0</td>\n",
        "      <td>  1</td>\n",
        "      <td> 0</td>\n",
        "      <td>  0</td>\n",
        "      <td> 13</td>\n",
        "      <td> 0</td>\n",
        "      <td>  4</td>\n",
        "      <td> 17</td>\n",
        "      <td> None</td>\n",
        "      <td> None</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "      <th>2</th>\n",
        "      <td> 1871</td>\n",
        "      <td> BS1</td>\n",
        "      <td> NA</td>\n",
        "      <td> birdsda01</td>\n",
        "      <td> 29</td>\n",
        "      <td> None</td>\n",
        "      <td> 29</td>\n",
        "      <td> 29</td>\n",
        "      <td> 0</td>\n",
        "      <td> 7</td>\n",
        "      <td>  0</td>\n",
        "      <td>  0</td>\n",
        "      <td> 0</td>\n",
        "      <td>  0</td>\n",
        "      <td>  0</td>\n",
        "      <td> 0</td>\n",
        "      <td> 27</td>\n",
        "      <td> 27</td>\n",
        "      <td> None</td>\n",
        "      <td> None</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "      <th>3</th>\n",
        "      <td> 1871</td>\n",
        "      <td> BS1</td>\n",
        "      <td> NA</td>\n",
        "      <td>  conefr01</td>\n",
        "      <td> 19</td>\n",
        "      <td> None</td>\n",
        "      <td> 19</td>\n",
        "      <td> 19</td>\n",
        "      <td> 0</td>\n",
        "      <td> 0</td>\n",
        "      <td>  0</td>\n",
        "      <td>  0</td>\n",
        "      <td> 0</td>\n",
        "      <td>  0</td>\n",
        "      <td> 18</td>\n",
        "      <td> 0</td>\n",
        "      <td>  1</td>\n",
        "      <td> 18</td>\n",
        "      <td> None</td>\n",
        "      <td> None</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "      <th>4</th>\n",
        "      <td> 1871</td>\n",
        "      <td> BS1</td>\n",
        "      <td> NA</td>\n",
        "      <td> gouldch01</td>\n",
        "      <td> 31</td>\n",
        "      <td> None</td>\n",
        "      <td> 31</td>\n",
        "      <td> 31</td>\n",
        "      <td> 0</td>\n",
        "      <td> 0</td>\n",
        "      <td> 30</td>\n",
        "      <td>  0</td>\n",
        "      <td> 0</td>\n",
        "      <td>  0</td>\n",
        "      <td>  0</td>\n",
        "      <td> 0</td>\n",
        "      <td>  1</td>\n",
        "      <td>  1</td>\n",
        "      <td> None</td>\n",
        "      <td> None</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "      <th>5</th>\n",
        "      <td> 1871</td>\n",
        "      <td> BS1</td>\n",
        "      <td> NA</td>\n",
        "      <td> jackssa01</td>\n",
        "      <td> 16</td>\n",
        "      <td> None</td>\n",
        "      <td> 16</td>\n",
        "      <td> 16</td>\n",
        "      <td> 0</td>\n",
        "      <td> 0</td>\n",
        "      <td>  0</td>\n",
        "      <td> 14</td>\n",
        "      <td> 0</td>\n",
        "      <td>  1</td>\n",
        "      <td>  0</td>\n",
        "      <td> 1</td>\n",
        "      <td>  0</td>\n",
        "      <td>  1</td>\n",
        "      <td> None</td>\n",
        "      <td> None</td>\n",
        "    </tr>\n",
        "  </tbody>\n",
        "</table>\n",
        "</div>"
       ],
       "metadata": {},
       "output_type": "pyout",
       "prompt_number": 19,
       "text": [
        "   yearID teamID lgID   playerID  G_all G_batting  G_defense  G_p  G_c  G_1b  \\\n",
        "0    1871    BS1   NA  barnero01     31      None         31   31    0     0   \n",
        "1    1871    BS1   NA  barrofr01     18      None         18   18    0     0   \n",
        "2    1871    BS1   NA  birdsda01     29      None         29   29    0     7   \n",
        "3    1871    BS1   NA   conefr01     19      None         19   19    0     0   \n",
        "4    1871    BS1   NA  gouldch01     31      None         31   31    0     0   \n",
        "5    1871    BS1   NA  jackssa01     16      None         16   16    0     0   \n",
        "\n",
        "   G_2b  G_3b  G_ss  G_lf  G_cf  G_rf  G_of  G_dh  G_ph  G_pr  \n",
        "0     0    16     0    15     0     0     0     0  None  None  \n",
        "1     0     1     0     0    13     0     4    17  None  None  \n",
        "2     0     0     0     0     0     0    27    27  None  None  \n",
        "3     0     0     0     0    18     0     1    18  None  None  \n",
        "4    30     0     0     0     0     0     1     1  None  None  \n",
        "5     0    14     0     1     0     1     0     1  None  None  "
       ]
      }
     ],
     "prompt_number": 19
    },
    {
     "cell_type": "code",
     "collapsed": false,
     "input": [],
     "language": "python",
     "metadata": {},
     "outputs": [],
     "prompt_number": 19
    }
   ],
   "metadata": {}
  }
 ]
}